Oracle Report Title Syntax

1. TTITLE : TTITLE is the command that defines a page header. You can abbreviate it to TTI.
2. LEFT: Tells SQL*Plus to align subsequent text with the left edge of the page.
3. "COIN Database": This text will print as part of the first title line, and it will start on the left side of the page.
4. -: The hyphen continues the TTITLE command to another line.
5. RIGHT: Tells SQL*Plus to align subsequent text with the right edge of the page.
6. “Page”: Is a literal that will be printed in front of the page number.
7. FORMAT 999: This format specification is applied to any numbers, in this case the page number, that subsequently appear in the page header.
8. SQL.PNO: This is a special construct that SQL*Plus recognizes, and replaces with the actual page number.
9. -: The hyphen continues the TTITLE command to another line.
10. SKIP 1: Tells SQL*Plus to advance one line.
11. CENTER: Tells SQL*Plus to center the text that follows.
12. "Database Object Report": This is the report name, and it will be centered on the second title line.
13. -: The hyphen continues the TTITLE command to another line.
14. SKIP 6: Tells SQL*Plus to advance six lines, in order to leave some space between the page heading and the column data.