Home » SQL & PL/SQL » SQL & PL/SQL » To see the Trigger statement....
To see the Trigger statement.... [message #7889] Tue, 15 July 2003 08:20 Go to next message
BABU SRSB
Messages: 42
Registered: June 2002
Member
Hi All,

I have created a Trigger. Now, i want to see my trigger statements, what i written from my SQL PLUS.
Please tell me, How can i do this.

Awaiting your valuble response.

Thanks & Regards,

Babu.

Report message to a moderator

Re: To see the Trigger statement.... [message #7892 is a reply to message #7889] Tue, 15 July 2003 10:32 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The trigger source is available via the USER_TRIGGERS view. You will have to 
SET LONG 10000
(or some higher number) to fully display the TRIGGER_BODY column in SQL*Plus.

Report message to a moderator

Re: To see the Trigger statement.... [message #7925 is a reply to message #7892] Thu, 17 July 2003 01:01 Go to previous message
BABU SRSB
Messages: 42
Registered: June 2002
Member
Thanks Todd.
and Many many thanks to this forum...

Regards,

Babu.

Report message to a moderator

Previous Topic: auto numbering records in a query
Next Topic: Calling batch file from PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:32:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.