Home » SQL & PL/SQL » SQL & PL/SQL » System table containing package information
System table containing package information [message #19085] Wed, 27 February 2002 14:38 Go to next message
ramesh
Messages: 123
Registered: August 2000
Senior Member
Hi,

Which is the system table/view which contains information related to the procedures and packages belonging to a user?
And is it possible to view the contents of a procedure on the display using sqlplus?

Thanks,
Ramesh

Report message to a moderator

Re: System table containing package information [message #19092 is a reply to message #19085] Thu, 28 February 2002 01:22 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
select text from user_source where name='your_package_or_procedure_name'

Report message to a moderator

Previous Topic: Query ?
Next Topic: dynamically populating a list item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 11:55:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.