Triggers

[dandamudi padma]

Hi, can anyboby tell how to write triggers as my req is if a row is inserted in table1 the same row has to be inserted on table2.. regards padma padma

[pmarfleet]

Have you read the documentation? What code have you written so far?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[dandamudi padma]

hi till now i wrote CREATE TRIGGER trginsert AFTER INSERT ON table1 FOR EACH ROW INSERT INTO table2(unit,id) values('888','999'); i will get data through a device whenever a record is inserted into the master table the same record has to be added into another table this is my req hope i was clear padma

[pmarfleet]

When a trigger fires for an insert/update, the new data can be accessed through a logical table named inserted.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush