Hi. I want to create a BEFORE INSERT trigger for a table 'Manager'. I want the trigger to automatically calculate the manager_id value from a sequence.
I've done the following...
CREATE OR REPLACE TRIGGER manager_trig
BEFORE INSERT ON Manager
FOR EACH ROW
WHEN (NEW.manager_id > 0)
And create the sequence.....
CREATE SEQUENCE manager_seq START WITH 1
INCREMENT BY 1;
I also want to also create a PL block that shows the trigger working, when INSERT,