Formatting Your Output

SQL*Plus also has commands that enable you to arrange your output in almost any format. This section covers the basic formatting commands for creating report titles, column headings, and formats, and for giving a column a new value.


TTITLE and BTITLE enable you to create titles on your reports. Previous days covered queries and output, but with SQL*Plus you can convert simple output into presentable reports. The TTITLE command places a title at the top of each page of your output or report. BTITLE places a title at the bottom of each page of your report. Many options are available with each of these commands, but today's presentation covers the essentials.

Here is the basic syntax of TTITLE and BTITLE ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition 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.