keala
Uploaded by
21 SLIDES
353 VUES
210LIKES

Creating Readable Reports in SQL*Plus: Formatting, Headers, and Data Display

DESCRIPTION

This chapter provides a comprehensive guide on formatting output in SQL*Plus to produce readable reports. Key commands such as COLUMN and FORMAT are explained to customize data display and column headings. Learn to use the SET command to modify the UNDERLINE variable, along with TTITLE and BTITLE for adding headers and footers. The BREAK command is highlighted for suppressing duplicate data and allowing blank lines after groups. Additionally, the SPOOL command is covered to save results to a text file, enhancing data reporting capabilities.

1 / 21

Télécharger la présentation

Creating Readable Reports in SQL*Plus: Formatting, Headers, and Data Display

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 14Formatting Readable Output

  2. Basic Report Creation in SQL*Plus • Enter format for the report • Enter a query to retrieve data

  3. COLUMN Command Formats both column heading and data displayed in column

  4. COLUMN Command Options

  5. FORMAT Option Specifies format model for the data

  6. FORMAT Example

  7. HEADING Option Specifies a column heading

  8. Output with HEADING Option

  9. SET Command • SET command used to change the UNDERLINE variable • Assign blank space to add separator with FORMAT option of COLUMN command

  10. Modified Report

  11. NULL Option Provides substitute for NULL values

  12. Report Headers and Footers • Header • Appears at top of reports • Created with TTITLE command • Footer • Appears at bottom of reports • Created with BTITLE command

  13. TTITLE and BTITLE Options

  14. SQL*Plus Variables

  15. BREAK Command • Suppresses duplicate data • Allows blank lines after groups

  16. BREAK Command Example

  17. CLEAR Command Used to clear settings applied to the BREAK and COLUMN commands

  18. COMPUTE Command Can include AVG, SUM, COUNT, MAX, or MIN keywords

  19. COMPUTE Command Example

  20. SPOOL Command Saves results to text file

  21. SPOOL Command Example

More Related