Trigger from two tables
Hi everyone!
I'm trying to do a trigger based on two tables, here's the problem: I have two tables, one is "delegacao" the other one "country", what I'm trying to do is make a trigger that before a new record is saved into the table "delegacao" it checks the table "country" and updates the value of the atributte "codigo" in the table "delegacao" with the same value of the table "country" (both tables have the atributte "codigo")
Thanks in advance
Subject
Views
Written By
Posted
Trigger from two tables
1849
November 15, 2011 11:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.