FreeLists / oracle-l / More than one table for a Triggers

[Kean Jacinta <jacintakean@xxxxxxxxx>]

Hi :) 

I know that one trigger can be assign to only one
table.
I have a situation here, Below are all the tables 

mapped_table
----------
mappedid --pk 
comid
empid
passportno

company_table
--------------
comid
comname
employee_table
---------------
empid
empname
passportno

The mapped_table takes the value from two other table
which is company and employee tables.

A trigger name :autoinsert_mapped_tr
This trigger will automatically takes value
comid,empid,passportno from both company and employee
table into mapped_table on insert and mappedid is a
seq number. 

Since trigger is tied to one table, how can the above
scenario be done? I didn't want to create 2 triggers ,
one for company on insert and another triggers for
employee on insert. 


Thank You
Jkean
 




 


                
__________________________________ 
Discover Yahoo! 
Use Yahoo! to plan a weekend, have fun online and more. Check it out! 
http://discover.yahoo.com/
--
http://www.freelists.org/webpage/oracle-l