OraFAQ Forum: SQL & PL/SQL » dbms

Home » SQL & PL/SQL » SQL & PL/SQL » dbms - packages

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

dbms - packages [message #1170]

Mon, 08 April 2002 04:15

ARANGASWAMY.V.
Messages: 29
Registered: April 2002

Junior Member

If we want to see the contents of the objects such tables,views, etc. We use 'DESCRIBE' command. Is there any such command to see the contents of the packages.

Report message to a moderator

Re: dbms - packages [message #1172 is a reply to message #1170]

Mon, 08 April 2002 06:08

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

select text from dba_source where name ='name_of_package'

---
u may use user_source also...
wrap wthis sql in an procedure...thats it!

Report message to a moderator

Re: dbms - packages [message #1181 is a reply to message #1170]

Tue, 09 April 2002 04:17

shri
Messages: 15
Registered: November 2001

Junior Member

try out this

select Text from user_source where Name ='Package_name'

this is give you the source code of that package.

or even try out with user_objects.

Report message to a moderator

Previous Topic:	Physical date
Next Topic:	sql help for(3 condition st)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:26:21 CDT 2024