Sql*Plus User’s Guide and Reference

Example 6–22
Displaying the Current Page Number in a Title
To display the current page number at the top of each page, along with the company 
name, enter the following command:
TTITLE LEFT 'ACME WIDGET' RIGHT 'PAGE:' SQL.PNO SKIP 2
Now rerun the current query:
/
ACME WIDGET
SALES DEPARTMENT PERSONNEL REPORT
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
6-22
SQL*Plus User's Guide and Reference
Note that SQL.PNO has a format ten spaces wide. You can change this format with the 
FORMAT clause of TTITLE (or BTITLE).
Example 6–23
Formatting a System-Maintained Value in a Title
To close up the space between the word PAGE: and the page number, reenter the 
TTITLE command as shown:
TTITLE LEFT 'ACME WIDGET' RIGHT 'PAGE:' FORMAT 999 -
SQL.PNO SKIP 2
Now rerun the query:
/
Listing, Suppressing, and Restoring Page Title Definitions
To list a page title definition, enter the appropriate title command with no clauses:
TTITLE
BTITLE
To suppress a title definition, enter:
TTITLE OFF
BTITLE OFF
ACMEWIDGET PAGE: 1
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.
ACME WIDGET 'PAGE:' 1
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-23
These commands cause SQL*Plus to cease displaying titles on reports, but do not clear 
the current definitions of the titles. You may restore the current definitions by 
entering:
TTITLE ON
BTITLE ON