SQL Command Line SET Commands

Previous

Next

The SQL Command Line SET commands can be used to specify various SQL Command Line settings, such as the format of the output from SQL SELECT statements. For example, the following SET commands specify the number of lines for each page and the number of characters for each line in the output:

SQL> SET PAGESIZE 200
SQL> SET LINESIZE 140

To enable output from PL/SQL blocks with DBMS_OUTPUT.PUT_LINE, use the following:

SQL> SET SERVEROUTPUT ON

To view all the settings, enter the following at the SQL prompt:

SQL> SHOW ALL

For information about the SQL Command Line SERVEROUTPUT setting to display output from a PL/SQL program, see "Inputting and Outputting Data with PL/SQL".