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