SQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88827-02 |
|
Command Reference, 11 of 52
BTI[TLE] [printspec [text|variable] ...] [ON|OFF]
Places and formats a specified title at the bottom of each report page, or lists the current BTITLE definition.
For a description of the old form of BTITLE, see Appendix F, "Obsolete SQL*Plus Commands".
Refer to the TTITLE command for additional information on terms and clauses in the BTITLE command syntax.
Enter BTITLE with no clauses to list the current BTITLE definition.
If you do not enter a printspec clause before the first occurrence of text, BTITLE left justifies the text. SQL*Plus interprets BTITLE in the new form if a valid printspec clause (LEFT, SKIP, COL, and so on) immediately follows the command name.
To set a bottom title with CORPORATE PLANNING DEPARTMENT on the left and a date on the right, enter
BTITLE LEFT 'CORPORATE PLANNING DEPARTMENT' - RIGHT '1 JAN 2001'
To set a bottom title with CONFIDENTIAL in column 50, followed by six spaces and a date, enter
BTITLE COL 50 'CONFIDENTIAL' TAB 6 '1 JAN 2001'
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|