Sql*Plus User’s Guide and Reference

Indenting a Title Element
You can use the COL clause in TTITLE or BTITLE to indent the title element a specific 
number of spaces. For example, COL 1 places the following values in the first 
character position, and so is equivalent to LEFT, or an indent of zero. COL 15 places 
the title element in the 15th character position, indenting it 14 spaces.
Example 6–21
Indenting a Title Element
To print the company name left-aligned with the report name indented five spaces on 
the next line, enter
TTITLE LEFT 'ACME WIDGET' SKIP 1 -
COL 6 'SALES DEPARTMENT PERSONNEL REPORT' SKIP 2
Now rerun the current query to see the results:
/
A C M E W I D G E T
====================
PERSONNEL REPORT SALES DEPARTMENT
DEPARTMENT_ID LAST_NAME SALARY
------------- ------------------------- ----------
30 Colmenares 2500
30 Himuro 2600
30 Tobias 2800
30 Baida 2900
30 Khoo 3100
30 Raphaely 11000
COMPANY CONFIDENTIAL
6 rows selected.

---

Defining Page and Report Titles and Dimensions
Formatting SQL*Plus Reports
6-21
Entering Long Titles
If you need to enter a title greater than 500 characters in length, you can use the 
SQL*Plus command DEFINE to place the text of each line of the title in a separate 
substitution variable:
DEFINE LINE1 = 'This is the first line...'
DEFINE LINE2 = 'This is the second line...'
DEFINE LINE3 = 'This is the third line...'
Then, reference the variables in your TTITLE or BTITLE command as follows:
TTITLE CENTER LINE1 SKIP 1 CENTER LINE2 SKIP 1 -
CENTER LINE3
Displaying System-Maintained Values in Titles
You can display the current page number and other system-maintained values in your 
title by entering a system value name as a title element, for example:
TTITLE LEFT 
system-maintained_value_name
There are five system-maintained values you can display in titles, the most commonly 
used of which is SQL.PNO (the current page number). See 
TTITLE
 on page 12-187 for 
a list of system-maintained values you can display in titles.