Category: SQLPlus

COLUMN command Specifies display characteristics for a given column or lists the current display characteristics for a single column or for all columns. COLUMN Command Syntax: COL[UMN] [{column|expr} [option …]] option is one of the next clauses: ALI[AS] alias CLE[AR] ENTMAP...

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...

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’)/...

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...

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...