Home » RDBMS Server » Performance Tuning » get proc and package names
get proc and package names [message #65994] Thu, 17 February 2005 21:51 Go to next message
Vinu
Messages: 13
Registered: March 2003
Junior Member
how to get the list of procedrue names and package name in my database.....

Regards,
Vinu
Re: get proc and package names [message #65995 is a reply to message #65994] Thu, 17 February 2005 22:14 Go to previous messageGo to next message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
SELECT object_name,object_type FROM dba_objects
WHERE object_type IN ('PROCEDURE','PACKAGE')
Re: get proc and package names [message #65996 is a reply to message #65995] Thu, 17 February 2005 22:16 Go to previous message
Vinu
Messages: 13
Registered: March 2003
Junior Member
Thanks sreedhar
Previous Topic: Urgent:How to find long running query in Oracle
Next Topic: same statement reparsing again.Pl help
Goto Forum:
  


Current Time: Tue Feb 27 01:44:50 CST 2024