To display messages in PL/SQL , the ___________ should be set ________________.

Options
- SERVEROUTPUT ,ON
- SERVEROUTPUT ,OFF
- DBMS_OUTPUT ,OFF
- PUT_LINE ,ON


CORRECT ANSWER : SERVEROUTPUT ,ON

Discussion Board
SET SERVEROUTPUT ON

To display messages in PL/SQL, the SERVEROUTPUT should be set ON. The SQL*Plus command 'set serveroutput on' causes SQL*Plus to retrieve and display the buffer.

Prajakta Pandit 02-22-2017 01:25 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement