SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?

SQL Interview Question
SQL Interview Question

Answer:

Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?
1. DBMS_DISPLAY
2. DBMS_OUTPUT
3. DBMS_LIST
4. DBMS_DESCRIBE

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Under which circumstance must you recompile the package body after recompiling the package specification?Which Oracle supplied package will enable this feature?