Answers

Question and Answer:

  Home  Oracle Scenarios

⟩ Explain How can we 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,....

 138 views

More Questions for you: