Dear Sir,
Can anyone tell me how to find out the contents(text) of a trigger... I have a trigger by name say trig and I would like to know the coding behind this trigger..
Regards,
K.Diwakar
Printable View
Dear Sir,
Can anyone tell me how to find out the contents(text) of a trigger... I have a trigger by name say trig and I would like to know the coding behind this trigger..
Regards,
K.Diwakar
USER_TRIGGERS
columns -
trigger_name
trigger_body - Coding behind trigger..
Sameer
Code:set long 1000
select trigger_body from dba_triggers where trigger_name = 'TRIG'
Thanks for your suggestions...
Regards,
K.Diwakar