Re: Database Triggers

Posted by ErmanArslansOracleBlog on Nov 07, 2017; 8:27am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-Triggers-tp4289p4290.html

1)Who is the owner of the trigger?
2)what happens when you create trigger with the following ->

create or replace TRIGGER DUMMY_HRPERSAL_TRIGGER AFTER INSERT OR UPDATE ON DUMMY_PER_GEN_DET FOR EACH ROW WHEN (new.R_INDICATOR = '0')
BEGIN INSERT INTO HR_USER.DUMMY_PERSON (PERSALNO,COL_SEQ) VALUES (:new.PERSALNO,DUMMY_HRPERSAL_SEQ.NEXTVAL); END;

(change - HR_USER.DUMMY_PERSON)