Name
TTITLE
Synopsis
TTI[TLE] [OFF | ON] |
[COL x | S[KIP] x | TAB x | LE[FT] |
CE[NTER] | R[IGHT] | BOLD | FOR[MAT]
format_spec | text | variable...]
The TTITLE command defines page titles for a report. For example:
TTITLE CENTER 'The Fictional Company' SKIP 3 - LEFT 'I.S. Department' - RIGHT 'Project Hours and Dollars Report' TITLE RIGHT FORMAT 999 SQL.PNO
Issuing the TTITLE command with no parameters causes SQL*Plus to display the current setting.
Parameters
- OFF
Turns off the page title but does not erase its definition.
- ON
Turns on the printing of page titles.
- COL x
Causes any title text following this parameter to print at the specified column position.
- S[KIP] x
Inserts the specified number of line breaks before printing any subsequent title text.
- TAB x
Skips forward the specified number of character columns. Negative values cause SQL*Plus to skip backwards.
- LE[FT]
Causes subsequent title text to be printed beginning at the leftmost column of the current title line.
- CE[NTER]
Causes subsequent title text to be centered within the current line.
- R[IGHT]
Causes subsequent title text to be printed flush right.
- BOLD
Makes your title bold by printing it three times. Only title text following the BOLD command is repeated on each line.
- FOR[MAT]
Allows you to control how subsequent numeric data in the title is displayed.
- format_spec
Is a string that specifies the display format to use for subsequent numeric data in the title.
- text
Is any text you want to have in the title.
- variable
Inserts the value of the specified ...
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.