Trigger to automatically add values to a table in Oracle
Sounds like you just want a basic AFTER INSERT trigger. Then you can access the inserted data via :new. Something like:


CREATE OR REPLACE TRIGGER insert_data
AFTER INSERT
ON OWNER.TABLE
FOR EACH ROW
BEGIN
INSERT INTO OWNER.OTHER_TABLE
(COL1,
COL2,
COL3)
VALUES
(:NEW.COL1,
:NEW,COL2,
:NEW,COL3)
END;