Re: How can I make this trigger?

goggle trigger oracle,

or http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=aeaa2c%2470p%241%40wanadoo.fr

could provide some programmatic items you could use.

regards

s.kapitza

galkas_at_mail.ru (Galina) wrote in message news:<ecdc865.0402020610.6e1f3e85_at_posting.google.com>...
> Hello
> I work with Oracle 9 database. I want to create a trigger using 2
> tables: KEY_SKILLS_STUDENT and KEY_SKILLS. There are fields in
> KEY_SKILLS_STUDENT: KEY_SKILLS_ID, PORTFOLIO_RESULT and ACHIEVED. The
> trigger should update automatically the field ACHIEVED to TRUE (-1),
> when PORTFOLIO_RESULT is updated with strings "Pass" or "Exempt", but
> not always. A field KEY_SKILLS_ID is a link to KEY_SKILLS table.
> KEY_SKILLS table has got fields KEY_SKILLS_AREA_ID and KEY_SKILLS_ID.
> I want the trigger to work, only if KEY_SKILLS_AREA_ID is >3.
> I am not very experienced with Oracle triggers. I have made a couple
> in my life, but they were much simpler, on a single table. Please
> could you post me an example of a code for such trigger, or to point
> into a right direction.
> Thank you very much.
Received on Mon Feb 02 2004 - 21:30:53 CET