Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

pl sql oracle trigger update exclude site:stackoverflow.com

CREATE OR REPLACE TRIGGER TABLE_TRIGGER_FUNCTION
   AFTER INSERT OR UPDATE
   OF FILEID, -- Field list starts here...
      DESCRIPTION,
      IMAGEID,
      STATETYPEID,
      ACCESSLEVELID,
      ACCESSLEVELID,
      FILETYPEID -- ... and ends here
   ON TABLE_TRIGGER
   REFERENCING NEW AS NEW OLD AS OLD
   FOR EACH ROW
BEGIN
    -- procedure();
END;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #pl #sql #oracle #trigger #update #exclude
ADD COMMENT
Topic
Name
8+2 =