SET in the sqlplus

Display
Clear Screen	clear scr
	SELECT object_name, created FROM all_objects WHERE ROWNUM < 2; clear scr
Column Separators	SET COLSEP <column separator>
	set colsep ',' SELECT table_name, column_name, data_type FROM user_tab_cols WHERE ROWNUM < 10;
Display Headers	SET HEAD <OFF | ON>
	SELECT table_name FROM all_tables; set head off SELECT table_name FROM all_tables; set head on
Line Size	SET LINESIZE <integer>
	SELECT text FROM all_source WHERE ROWNUM < 21; set linesize 121 SELECT text FROM all_source WHERE ROWNUM < 21;
Page Size	SET PAGESIZE <integer>
	SELECT object_name FROM all_objects WHERE ROWNUM < 60; set pagesize 20 SELECT object_name FROM all_objects WHERE ROWNUM < 60; set pagesize 0 SELECT object_name FROM all_objects WHERE ROWNUM < 60;
Page Break	BREAK ON <column_name> [SKIP PAGE]
	break on overload skip page set pagesize 20 set linesize 121 col overload format a8 SELECT overload, position, argument_name, in_out, data_type FROM all_arguments WHERE object_name = 'CREATE_TUNING_TASK' ORDER BY overload, position;
Pause	SET PAUSE <OFF | ON>
	SELECT object_name FROM all_objects WHERE ROWNUM < 60; set pause on SELECT object_name FROM all_objects WHERE ROWNUM < 60; set pause off
Timing	SET TIMING <OFF | ON>
	SELECT COUNT(*) FROM all_objects WHERE SUBSTR(object_name,1,1) BETWEEN 'A' AND 'W'; set timing on SELECT COUNT(*) FROM all_objects WHERE SUBSTR(object_name,1,1) BETWEEN 'A' AND 'W'; set timing off
Title	ttitle {LEFT <text>} {CENTER <text>} {RIGHT <text>}
	set pagesize 25 ttitle LEFT '01-Jan-2005' CENTER 'University of Washington' RIGHT 'Page:' FORMAT 999 SQL.PNO SELECT * FROM DUAL; ttitle LEFT '01-Jan-2005' CENTER 'University of Washington' RIGHT 'Page:' FORMAT 999 SQL.PNO SKIP CENTER - 'Oracle Application Development' SELECT object_name FROM all_objects WHERE ROWNUM < 60;
Display Output From DBMS_OUTPUT.PUT_LINE built-in package	set serveroutput <ON | OFF>
	DECLARE x VARCHAR2(20) := 'This is a test'; BEGIN dbms_output.put_line(x); END; / set serveroutput on DECLARE x VARCHAR2(20) := 'This is a test'; BEGIN dbms_output.put_line(x); END; /