OraFAQ Forum: SQL & PL/SQL » how do i see the trigger description

Home » SQL & PL/SQL » SQL & PL/SQL » how do i see the trigger description

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

how do i see the trigger description [message #19129]

Fri, 01 March 2002 06:35

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
how do i see the trigger descriptio.
what is the select statement and view

Report message to a moderator

Re: how do i see the trigger description [message #19130 is a reply to message #19129]

Fri, 01 March 2002 07:47

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select * from user_triggers (or all_triggers or dba_triggers)

Report message to a moderator

Re: how do i see the trigger description [message #19132 is a reply to message #19129]

Fri, 01 March 2002 07:56

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
I want to see the complete description as it was created.
The table does not give the full script to see the total description (total created text of trigger)

How to see the total description of the trigger as it was created

Report message to a moderator

Re: how do i see the trigger description [message #19136 is a reply to message #19129]

Fri, 01 March 2002 09:30

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

There is no place where the complete trigger text as originally entered is stored, but everything you need to re-create it is right there in the user_triggers view.

You've got the name, type, event, table, etc. Just concatenate the applicable columns together to form the original statement.

Report message to a moderator

Previous Topic:	substring help
Next Topic:	One error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 15:06:52 CDT 2024