trigger [message #164899] |
Mon, 27 March 2006 06:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
eswaries
Messages: 41 Registered: January 2006
|
Member |
|
|
I HAVE CREATED TRIGGER named THING.But I don’t know in which notepad file ,I stored this trigger code. How can I know the trigger code? Please clarify.
|
|
|
Re: trigger [message #164903 is a reply to message #164899] |
Mon, 27 March 2006 07:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
From sqlplus give commands like:
sql>set long 10000
sql>select trigger_body from user_triggers where trigger_name='THING' ;
|
|
|