Oracle Scenarios Question:
Explain How can we see the source code of the package?
Answer:
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,....
WHERE NAME=<NAME OF THE PACKAGE> AND TYPE='PACKAGE';
HERE THE TYPE MAY BE PACKAGE,PROCEDURE,....