SQLPlus Clear
CLEAR Command Syntax: CL[EAR] option option can be one of the next clauses: BRE[AKS] BUFF[ER] COL[UMNS] COMP[UTES] SCR[EEN] SQL TIMI[NG] CLEAR Command Examples: CLEAR BREAKS CLEAR BUFFER CLEAR COLUMNS CLEAR SCREEN...
Author: codertutor_3o6d0o
SQLPlus Change
CHANGE Command Syntax: C[HANGE] sepchar old [sepchar [new [sepchar]]] CHANGE Command Examples: 3* WHERE offer_status IS IN (‘ACTIVE’, ‘EXPIRED’) CHANGE /ACTIVE/NO_ACTIVE/ 3* WHERE offer_status IS IN (‘NO_ACTIVE’) CHANGE /(…)/(‘YES_ACTIVE’)/...
SQLPLus Btitle
BTITLE Command Syntax: BTI[TLE] [printspec [text|variable] …] [ON|OFF] printspec can be one or more of the next clauses: COL n , CE[NTER] , R[IGHT] , LE[FT] , S[KIP] [n] , TAB n , BOLD , FORMAT text BTITLE Command Examples: BTITLE...
SQLPlus Break
BREAK Command Syntax: BRE[AK] [ON report_element [action [action]]] report_element – {column|expr|ROW|REPORT} action – [SKI[P] n|[SKI[P]] PAGE][NODUP[LICATES]|DUP[LICATES]] The command BREAK determines: – Dividing lines into sections and suppressing duplicate values; – Insert a blank line every time the value of a column...
SQLPlus Attribute
ATTRIBUTE Command Syntax: ATTRIBUTE [type_name.attribute_name [option …]] option can be one of the clauses: ALI[AS] alias CLE[AR] FOR[MAT] format LIKE {type_name.attribute_name|alias} ON|OFF ATTRIBUTE Command Examples: ATTRIBUTE CUSTOMER_TYPE.NAME FORMAT A20 ATTRIBUTE CUSTOMER_TYPE.AMOUNT FORMAT $9,999,990.99...