|SQL*Plus User's Guide and Reference
Command Reference, 11 of 52
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.
BTI[TLE] [printspec [text|variable] ...]|[OFF|ON]
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
SQL> BTITLE LEFT 'CORPORATE PLANNING DEPARTMENT' - > RIGHT '23 Nov 1998'
To set a bottom title with CONFIDENTIAL in column 50, followed by six spaces and a date, enter
SQL> BTITLE COL 50 'CONFIDENTIAL' TAB 6 '23 Nov 1998'
Copyright © 1999 Oracle Corporation.
All Rights Reserved.