OraFAQ Forum: SQL & PL/SQL » How can I view the trigger definition in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » How can I view the trigger definition in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I view the trigger definition in Oracle [message #21319]

Thu, 25 July 2002 23:24

Srinivas
Messages: 138
Registered: June 2000

Senior Member

How can I view the trigger definition in Oracle

Report message to a moderator

Re: How can I view the trigger definition in Oracle [message #21320 is a reply to message #21319]

Fri, 26 July 2002 00:36

Laxman Chepuri
Messages: 8
Registered: May 2002

Junior Member

See the table USER_TRIGGERS

Report message to a moderator

Re: How can I view the trigger definition in Oracle [message #21322 is a reply to message #21319]

Fri, 26 July 2002 01:06

Srinivas
Messages: 138
Registered: June 2000

Senior Member

But I can not see the total code written for this trigger there, I do not know whether it is distributed across number if fields/tables.

Report message to a moderator

Re: How can I view the trigger definition in Oracle [message #21338 is a reply to message #21319]

Fri, 26 July 2002 09:25

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

A trigger is only associated with a single table. As has already been posted, you can see all code for a trigger in user_triggers - everything you need is there.

Report message to a moderator

Previous Topic:	Returned vArray problem
Next Topic:	fetching the current and previous column value for the current record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:04:15 CDT 2024