I built two Tests Test, Test2Create Table Test (Aa Number (20), BB NVARCHAR2 (20));
Create Table Test2 (AA Number (20), BB NVARCHAR2 (20));
My thoughts are inserted to Test, then insert a record for Test2
Create Or Replace Trigger Myt Before Insert On Test for Each RowDeclare - Local Variables HerebeginInsert Into Test2 (AA, BB) VALUES (: new.aa,: new.bb);
End myt;
INSERT INTO TEST (AA, BB) VALUES (1, 2);
INSERT INTO TEST (AA, BB) VALUES (3, 4);
COMMIT;
: new.aa,: new.bb is worth new recorded, AA, BB inside TEST
