Home » SQL & PL/SQL » SQL & PL/SQL » viewing triggers and procedures
viewing triggers and procedures [message #185099] Mon, 31 July 2006 00:38 Go to next message
balmcacit05
Messages: 6
Registered: July 2006
Junior Member
How to view all the triggers and procedures existing in the database. is there any query for that. can anybody help me out
Re: viewing triggers and procedures [message #185101 is a reply to message #185099] Mon, 31 July 2006 00:42 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

To find the object name

select * from user_objects


To view the text
Select * from user_source


Naveen

[Updated on: Mon, 31 July 2006 00:45]

Report message to a moderator

Re: viewing triggers and procedures [message #185298 is a reply to message #185099] Tue, 01 August 2006 02:07 Go to previous messageGo to next message
anand_mohanty
Messages: 2
Registered: July 2006
Location: Mumbai
Junior Member

if u are using toad software...there is a option "schema browser"...which allows u to view all the tables,procedures,triggers,functions ....existing in da database.
icon3.gif  Re: viewing triggers and procedures [message #185358 is a reply to message #185099] Tue, 01 August 2006 05:50 Go to previous message
vino4ever
Messages: 11
Registered: July 2006
Location: Chennai
Junior Member
You can use the OBJECT_TYPE column in User Objects to identify the triggers and TYPE column in USER_SOURCE to find the source of the trigger.
Previous Topic: Query
Next Topic: lock timeout
Goto Forum:
  


Current Time: Sun Dec 04 21:01:21 CST 2016

Total time taken to generate the page: 0.10433 seconds