Appendix B. SQL*Plus Format Elements

Several SQL*Plus commands control data formats using what is called a format specification. A format specification is a string of characters that tells SQL*Plus exactly how to format a number, date, or text string when it is displayed. The most notable of these commands is the COLUMN command, which is used to format columns of output from a SELECT query. Other commands exist as well. The complete list of SQL*Plus commands that accept format specification strings is shown here:


Prompts the user to enter a value from the keyboard.


Controls various aspects of the way a column of data is displayed.


Defines the default display format for numbers .


Allow number format specifications to control the way numbers are formatted in page headers, page footers, report headers, and report footers.

There are three different broad types of values SQL*Plus can format: numbers, character strings, and dates. Not all commands can handle each type. With most commands, you can specify only number and date formats. The COLUMN command is a good example. The ACCEPT command is the only one that allows you to specify a date format string.

Format specification strings are made up of special characters that have meaning to SQL*Plus in the context of formatting a value for display. Numeric format strings, for example, tend to have many 0s, 9s, decimal points, and dollar signs. Date format strings tend to include things like MM, DD, YYYY, etc. Character string formats are the simplest of all because you have only one thing you can influence: length.


Introduction to SQL*Plus

Command-Line SQL*Plus

Browser-Based SQL*Plus

A Lightning SQL Tutorial

Generating Reports with SQL*Plus

Creating HTML Reports

Advanced Reports

Writing SQL*Plus Scripts

Extracting and Loading Data

Exploring Your Database

Advanced Scripting

Tuning and Timing

The Product User Profile

Customizing Your SQL*Plus Environment

Appendix A. SQL*Plus Command Reference

Appendix B. SQL*Plus Format Elements

Oracle SQL Plus The Definitive Guide, 2nd Edition
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
EAN: 2147483647
Year: N/A
Pages: 151 © 2008-2020.
If you may any questions please contact us: