SQL*Plus
User's Guide and Reference
Release 8.1.6 A75664-01 |
|
Command Reference, 48 of 52
Places and formats a specified title at the top of each report
page or lists the current TTITLE definition. The old form of TTITLE is
used if only a single word or string in quotes follows the TTITLE command.
For a description of the old form of TTITLE, see TTITLE
in Appendix F.
TTI[TLE] [printspec [text|variable] ...] [ON|OFF]
where printspec represents one or more of the following clauses used to place and format the text:
COL n S[KIP] [n] TAB n LE[FT] CE[NTER] R[IGHT] BOLD FORMAT text
Refer to the following list for a description of each term or clause. These terms and clauses also apply to the BTITLE command.
Represents a user variable or any of the following system-maintained values:
To print one of these values, reference the appropriate variable in the title. You can format variable with the FORMAT clause.
Left-align, center, and right-align data on the current line respectively. SQL*Plus aligns following data items as a group, up to the end of the printspec or the next LEFT, CENTER, RIGHT, or COL command. CENTER and RIGHT use the SET LINESIZE value to calculate the position of the data item that follows.
Specifies a format model that determines the format of following
data items, up to the next FORMAT clause or the end of the command. The
format model must be a text constant such as A10 or $999. See the
COLUMN FORMAT command for more information
on formatting and valid format models.
If the datatype of the format model does not match the datatype
of a given data item, the FORMAT clause has no effect on that item.
If no appropriate FORMAT model precedes a given data item,
SQL*Plus prints NUMBER values according to the format specified by SET
NUMFORMAT or, if you have not used SET NUMFORMAT, the default format. SQL*Plus
prints DATE values according to the default format.
Refer to the FORMAT clause of the COLUMN command in this chapter for more information on default formats.
Enter TTITLE with no clauses to list the current TTITLE definition.
If you do not enter a printspec clause before the
first occurrence of text, TTITLE left justifies the text. SQL*Plus
interprets TTITLE in the new form if a valid printspec clause (LEFT,
SKIP, COL, and so on) immediately follows the command name.
See COLUMN NEW_VALUE for
information on printing column and DATE values in the top title.
You can use any number of constants and variables in a printspec.
SQL*Plus displays the constants and variables in the order you specify
them, positioning and formatting each constant or variable as specified
by the printspec clauses that precede it.
The length of the title you specify with TTITLE cannot exceed
2400 characters.
The continuation character (a hyphen) will not be recognized inside a single-quoted title text string. To be recognized, the continuation character must appear outside the quotes, as follows:
SQL> TTITLE CENTER 'Summary Report for' - > 'the Month of May'
To define "Monthly Analysis" as the top title and to left-align it, to center the date, to right-align the page number with a three-digit format, and to display "Data in Thousands" in the center of the next line, enter
SQL> TTITLE LEFT 'Monthly Analysis' CENTER '23 Nov 99' - > RIGHT 'Page:' FORMAT 999 SQL.PNO SKIP CENTER - > 'Data in Thousands'
The following title results:
Monthly Analysis 23 Nov 99 Page: 1 Data in Thousands
To suppress the top title display without changing its definition, enter
SQL> TTITLE OFF
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|