Oracle Scenarios Question:
Download Questions PDF

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,....

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Explain In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?