Author: codertutor_3o6d0o

VARIABLE Command Syntax: VAR[IABLE] [variable [NUMBER|CHAR|CHAR (n [CHAR|BYTE])|NCHAR|NCHAR (n) |VARCHAR2 (n [CHAR|BYTE])|NVARCHAR2 (n)|CLOB|NCLOB|REFCURSOR]] VARIABLE Command Examples: VARIABLE id NUMBER VARIABLE text CHAR (20) VARIABLE var REFCURSOR SET AUTOPRINT ON VARIABLE var REFCURSOR BEGIN OPEN :var FOR SELECT id, name, city, email...

UNDEFINE Command Syntax: UNDEFINE variable … UNDEFINE Command Example: Undefine a single varibale: UNDEFINE var Undefine two varibales: UNDEFINE var1 var2...

TTITLE Command Syntax: TTITLE [printspec [text|variable] …] [ON|OFF] TTITLE Command Example: TTITLE LEFT ‘Monthly Sales’ CENTER ’01 Dec 2011′ RIGHT ‘Page:’ FORMAT 999 SQL.PNO SKIP CENTER ‘Data in sales’ TTITLE OFF...

TIMING Command Syntax: TIMING [START text|SHOW|STOP] TIMING Command Example: TIMING START SQL_TIMER TIMING SHOW TIMING STOP...

STORE Command Syntax: STORE SET file[.ext] [CRE[ATE]|REP[LACE]|APP[END]] STORE Command Example: STORE SET test STORE SET test.old APPEND...