Create a trigger

Hello,

I need to create two triggers in an Oracle database, but I don't know PL/SQL. I have:

• a table called "illustration" with 2 columns ('ilu_id', 'ilu_path')
• a table called "container" with 2 columns ('ctn_id', 'ctn_path')
• a third table "illustration_composition" with 2 columns ('ilu_id', 'ctn_id') is used to make the relations between thos two tables.
  1. When The field ilu_path is modified, the field ctn_path must be updated with the same value.
  2. When there is a new association between the tables illustration and container, field ctn_path must be set with the value of ilu_path.

I think the code of those two triggers are not so difficult, but I don't know at all the PL/SQL.
Can somebody help me ?

Thanks a lot. Received on Thu Apr 06 2000 - 10:29:28 CDT