My question is After inserting a row,I need to update some of the columns.How can I do with the after insert trigger.
See the codings below
.
CREATE OR REPLACE TRIGGER order_id_trg_up d
after INSERT
ON order_tb
For each row
BEGIN
update order_tb set transaction_dat e=sysdate where order_id = :new.order_id;
END order_id_trg_up d;
If I give this coding,it shows that mutating error.
How to come out of this problem?Please do the needful.
Regards,
Ravi Shanmuga Nagaraj P(RAVISHNA)
See the codings below
.
CREATE OR REPLACE TRIGGER order_id_trg_up d
after INSERT
ON order_tb
For each row
BEGIN
update order_tb set transaction_dat e=sysdate where order_id = :new.order_id;
END order_id_trg_up d;
If I give this coding,it shows that mutating error.
How to come out of this problem?Please do the needful.
Regards,
Ravi Shanmuga Nagaraj P(RAVISHNA)
Comment