Chapter 14 Formatting Readable Output

Chapter 14Formatting Readable Output

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

COLUMN Command Formats both column heading and data displayed in column

COLUMN Command Options

FORMAT Option Specifies format model for the data

FORMAT Example

HEADING Option Specifies a column heading

Output with HEADING Option

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

Modified Report

NULL Option Provides substitute for NULL values

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

TTITLE and BTITLE Options

SQL*Plus Variables

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

BREAK Command Example

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

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

COMPUTE Command Example

SPOOL Command Saves results to text file

SPOOL Command Example

Chapter 14 Formatting Readable Output

Chapter 14 Formatting Readable Output

Presentation Transcript

Chapter 6 Output

Chapter 6 Output

Chapter 6 - Output

Formatting the Output

Output formatting

Output Formatting

Line Continuation, Output Formatting, and Decision Structures

Producing Readable Output with SQL*Plus

Producing Readable Output with i SQL*Plus

The Scanner Class and Formatting Output

Formatting Screen Input/Output

Moving Data, Printing Information, and Formatting Output

Formatting Output

Formatting Output

Producing Readable Output With SQL * Plus (Continued)

Math Operators and Output Formatting

Chapter Twenty One Producing Readable Output

Output Formatting

Chapter 14 Output stage and power amplifier

Chapter 6 Output

Producing Readable Output with i SQL*Plus

Formatting Output