Home » SQL & PL/SQL » SQL & PL/SQL » trigger source code
trigger source code [message #39072] Wed, 12 June 2002 02:42 Go to next message
aubry Sylvie
Messages: 1
Registered: June 2002
Junior Member
how can I see the full trigger_body of a Trigger ?
If I select trigger_body from user_triggers, I just get the 3 first lines
Re: trigger source code [message #39073 is a reply to message #39072] Wed, 12 June 2002 04:47 Go to previous message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
That is because trigger_body is declared as long.
If you do SET LONG <some big number> you will see
complete body. Do SET LONG 10000 then select * from
user_body where....
Previous Topic: Hierachical Dynaset
Next Topic: Re: problem with for loop
Goto Forum:
  


Current Time: Thu Apr 25 03:09:49 CDT 2024