Scenarios - How can you see the source code of the package

GeekInterview.com > Interview Questions > Oracle > Scenarios

Go To First | Previous Question | Next Question

Scenarios | Question 5 of 25

How can you see the source code of the package

Total Answers and Comments: 7

Last Update: May 20, 2006

Sponsored Links

Best Rated Answer

—

Submitted by: narasimha reddy

SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCE

WHERE

Above answer was rated as good by the following members:
ds_devi

July 04, 2005 02:47:38

B.Vijay Karthik

RE: How can you see the source code of the package

Query user_source.text view for package procedure function source code

Is this answer useful? Yes | No

July 05, 2005 05:05:51

Rakesh Gautam

RE: How can you see the source code of the package

select text from dba_source where type 'PACKAGE' and name ' ';

Is this answer useful? Yes | No

August 29, 2005 03:47:58

Leon Parren

RE: How can you see the source code of the package

This only works if the package is not wrapped. The source code of

Is this answer useful? Yes | No

September 24, 2005 09:24:36

Sravan Anumala

RE: How can you see the source code of the package

source code of package resides in TEXT VARCHAR2(4000) column in the USER_SOURCE Data Dictionary Table

Is this answer useful? Yes | No

January 10, 2006 08:57:35

jagannimmagadda

Member Since: January 2006 Contribution: 6

RE: How can you see the source code of the package

for suppose package name is ABC select text from user_Source where type 'PACKAGE' and name 'ABC';

Is this answer useful? Yes | No

May 20, 2006 04:30:11

narasimha reddy

RE: How can you see the source code of the package

SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCE

WHERE

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 20, 2006 04:36:42

NARASIMHA REDDY

RE: How can you see the source code of the package

SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCE

WHERE NAME <NAME OF THE PACKAGE> AND TYPE 'PACKAGE';

HERE THE TYPE MAY BE PACKAGE PROCEDURE ....

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank