SQLPlus Whenever Oserror
WHENEVER OSERROR Syntax: WHENEVER OSERROR {EXIT [SUCCESS|FAILURE|n|variable|:BindVariable] [COMMIT|ROLLBACK] |CONTINUE [COMMIT|ROLLBACK|NONE]} WHENEVER OSERROR Examples: WHENEVER OSERROR EXIT START no_such_file...
Category: SQLPlus
SQLPlus Variable
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...
SQLPlus Undefine
UNDEFINE Command Syntax: UNDEFINE variable … UNDEFINE Command Example: Undefine a single varibale: UNDEFINE var Undefine two varibales: UNDEFINE var1 var2...
SQLPlus Ttitle
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...
SQLPlus Timing
TIMING Command Syntax: TIMING [START text|SHOW|STOP] TIMING Command Example: TIMING START SQL_TIMER TIMING SHOW TIMING STOP...