Oracle Scenarios Interview Question:

Explain How can we see the source code of the package?

Submitted by: Administrator

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,....
Submitted by: Administrator