Oracle trigger if updating then

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi I am currently using Oracle 9i, using the Scott database and have a number of contraints which I need to implement.

ID, tab2.col1, tab2.col2, tab2.idt1) values(seq2.nextval, :new.col1, :new.col2, :new. = :new.col1) or (:old.col1 is null and :new.col1 is not null) or (:old.col1 is not null and :new.col1 is null)begin ..... 9i Release 1 ) hence some of the demo tables/columns were not present. I am jotting down some of the triggers that I developed: ************************************************** ******************** Q1) No new orders are to be accepted from customers in the city of BURLINGAME. Insert/Update (Oracle): before insert - Oracle ( ) . Sorry, but that sounds like a very poor design, it violates almost every principle of normalization. I want to define a trigger that inserts only update records from TEST_CASE tables into TEST_CASE_UPDATES table. Sorry, but that sounds like a very poor design, it violates almost every principle of normalization. HI, i am trying to store the updated as well as inserted records from TEST_CASE table to TEST_CASE_UPDATES TABLE.

Leave a Reply