O'Reilly logo

Oracle SQL*Plus Pocket Reference by Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL*Plus Format Elements

The COLUMN, ACCEPT, SET NUMBER, TTITLE, BTITLE, REPHEADER, and REPFOOTER commands allow you to 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.

Formatting Numbers

Table 1.4 shows the format elements that may be used when formatting numeric output.

Table 1-4. Numeric Format Elements

Format

Element

Function

9

Represents a digit in the output.

0

Marks the spot at which you want to begin displaying leading zeros.

$

Includes a leading dollar sign in the output.

,

Places a comma in the output.

.

Marks the location of the decimal point.

B

Forces zero values to be displayed as blanks.

MI

Adds a trailing negative sign to a number and may be used only at the end of a format string.

S

Adds a + or - sign[a] to the number and may be used at either the beginning or end of a format string.

PR

Causes negative values to be displayed within angle brackets. For example, -123.99 will be displayed as <123.99>.

D

Marks the location of the decimal point.

G

Places a group separator (usually a comma) in the output.

C

Marks the place where you want the ISO currency indicator to appear. For U.S. dollars, this will be USD.

L

Marks the place where you want the local currency indicator to appear. For U.S. dollars, this will be the dollar sign character.

V

Displays scaled values. The number of digits to the right of the V indicates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required