iSQL*Plus User's Guide and Reference
Release 9.0.1

Part Number A88826-01
Go To Table Of Contents
Contents
Go To Index
Index

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

Command Reference, 9 of 38


BTITLE

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.

Terms | Usage | Examples | Top

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.

Usage | Terms | Examples | Top

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.

Examples | Terms | Usage | Top

To set a bottom title with CORPORATE PLANNING DEPARTMENT on the left and a date on the right, enter

Keyboard icon
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

Keyboard icon
BTITLE COL 50 'CONFIDENTIAL' TAB 6 '1 JAN 2001'

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

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index