PL/SQL (MOSC)

MOSC Banner

db trigger

edited Jan 24, 2012 1:47AM in PL/SQL (MOSC) 3 comments
I have a table called cust_file (cus_no number(3),cus_name varchar2(100))

and another table called
cust_file1 (cus_no1 number(3),cus_name1 varchar2(100))

there is a developed screen (.fmx) allowed user to insert
data in cust_file

I want to create a trigger on the database level
fire each time the user insert data on cust_file
 make each row inserted on cust_file also inserted on cust_file1

How can I perform this task.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center