RelationalDBDesign RelationalDBDesign


SQL* Plus CLI  «Prev 

Oracle Report Title Syntax

Oracle 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.