SQL*Plus Tutorial

SQL*Plus TTITLE / BTITLE Commands

TTITLE, BTITLE commands allow formatting of headers and footers page.

TTITLE / BTITLE Commands syntax

TTI [TLE] | [BTI [TLE] [specified_type [text | variable] ] [OFF | ON]

TTITLE / BTITLE commands without clause, lists the current definition of the header and the footer of the page.

BTITLE Command Examples

BTITLE LEFT 'STUDENTS LIST' RIGHT '1 FEB 2016'
BTITLE COL 50 'COURSES' TAB 3 '1 FEB 2016'

Database resources:  Transact-SQL,  Learn PLSQL