PL/SQL (MOSC)

MOSC Banner

trigger vs. performance issue

edited Feb 3, 2010 6:28AM in PL/SQL (MOSC) 15 commentsAnswered
  I have the following trigger:

create or replace trigger TRITON.AFTER_INSERT_UPDATE_ITM001100                                   
after insert or update on TRITON.TTIITM001100                                  
for each row                                                                   
declare                                                                        
v_reflag char(1) :='0';                                                        
begin                                                                          
if INSERTING then                                                              
insert into ticcrm.ttiitm001100_copy                                           
(T$ITEM,                                                                       
 T$DSCA,                                                                       
 T$DSCB,     
 T$DSCC,                                                                       
 T$DSCD,                                                                       
 T$WGHT,                                                                       
 T$SEAK,                                                                       
 T$SEAB,                                                                       
 T$KITM,                                                                       
 T$CITG,                                                                       
 T$CTYP,                                                                       
 T$CSEL,                                                                       
 T$CSIG,                                                                       
 T$CVAT,    
 T$TXTA,                                                                       
 T$USET,                                                                       
 T$CUNI,                                                                       
 T$STGU,                                                                       
 T$CWAR,                                                                       
 T$KLTC,                                                                       
 T$OBPR,                                                                       
 T$KPSL,                                                                       
 T$NPSL,                                                                       
 T$PICS,                                                                       
 T$ABCC,     
 T$USCU,                                                                       
 T$USAB,                                                                       
 T$SLMP,                                                                       
 T$SERV,                                                                       
 T$SFST,                                                                       
 T$MAXS,                                                                       

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center