DDL Source for TRIGGER a1.DMTEST.IL_TRIG1

This page was created on: 28 March 2017, 11:53

[ DB a1 Home ] [ Schema DMTEST Home ] [ TRIGGERS Home ] [ DDL Wizard Home ]

CREATE 
 trigger IL_trig1 
 after update on DM_INVOICE_LINE for each row
 BEGIN
   insert into DM_INVOICE_LINE_HISTORY (invoice_number,item_id,quantity) 
      values (:new.invoice_number,:new.inventory_item_id,:new.invoice_line_quantity);
 END IL_trig1;


[ DDL Wizard Home ]

This page was generated by the public version of the Net 2000 Ltd. DDLWizard software. Net 2000 Ltd. publishes other useful software for Oracle databases: Data Masker which replaces sensitive information in test and development databases with realistic looking anonymous data and DataBee the simplest and easiest way to create referentially correct subsets of large Oracle databases.