Automate creation of triggers with sequence for autoincrement
Automate creation of triggers with sequence for autoincrement like in Toad.
Example:
CREATE OR REPLACE TRIGGER STATUSTRG
BEFORE INSERT
ON TDR.STATUS
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
-- For Toad: Highlight column ID
:new.ID := TDR.STATUSSEQ.nextval;
END STATUS_TRG;
/
0
votes
Anonymous
shared this idea