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

Report message to a moderator

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')

Report message to a moderator

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

Report message to a moderator

Previous Topic: Urgent:How to find long running query in Oracle
Next Topic: same statement reparsing again.Pl help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 03 03:15:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.