SQL*Plus User's Guide and Reference
Release 9.0.1

Part Number A88827-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Obsolete SQL*Plus Commands, 2 of 15


SQL*Plus Obsolete Command Alternatives

Obsolete
Command
 
Alternative
Command
 
Description of Alternative Command 

BTITLE (old form)

 

BTITLE

 

Places and formats a title at the bottom of each report page or lists the current BTITLE definition. 

COLUMN DEFAULT

 

COLUMN CLE[AR]

 

Resets column display attributes to default values.  

DOCUMENT

 

REMARK

 

Places a comment which SQL*Plus does not interpret as a command.  

NEWPAGE

 

SET NEWP[AGE] {1|n|NONE}

 

Sets the number of blank lines to be printed from the top of each page to the top title. 

SET BUFFER

 

EDIT

 

Use the SQL*Plus SAVE, GET, @ and START commands to create and use external files.  

SET CLOSECURSOR

 

none

 

Obsolete 

SET DOCUMENT

 

none

 

Obsolete 

SET MAXDATA

 

none

 

Obsolete 

SET SCAN

 

SET DEF[INE] {&|c|ON|OFF}

 

Sets the character used to prefix substitution variables.  

SET SPACE

 

SET COLSEP {_|text}

 

Sets the text to be printed between SELECTed columns.  

SET TRUNCATE

 

SET WRA[P] {ON|OFF}

 

Controls whether SQL*Plus truncates a SELECTed row if it is too long for the current line width.  

SHOW LABEL

 

none

 

Obsolete 

TTITLE (old form)

 

TTITLE

 

Places and formats a title at the top of each report page or lists the current TTITLE definition.  


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback