Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Parameters

column_name

Name of the column you are formatting. If it is a computed column, the expression is the name. If your SELECT statement aliases the column, you must use that alias name here. Issuing the command COLUMN column_name with no further parameters causes SQL*Plus to display the current format for that column.

ALI[AS]

Allows you to specify an alternate name for the column that is meaningful.

alias

Alternate name for the column that may be used in BREAK commands, COMPUTE commands, and other COLUMN commands.

CLE[AR]

Erases any format settings for the column in question.

ENTMAP (ON | OFF)

Controls whether characters such as < and > should be represented as &lt; and &gt; in HTML reports. The default is to use the ENTMAP setting specified with the SET MARKUP command or -M command-line option.

FOLD_A[FTER]

Causes SQL*Plus to advance to a new line after printing this column.

FOLD_B[EFORE]

Causes SQL*Plus to advance to a new line before this column is printed.

FOR[MAT]

Allows you to control how the data for the column is displayed.

format_spec

String that specifies the display format for the column.

HEA[DING]

Allows you to define a heading for the column.

heading_text

Text you want for the column heading. This may optionally be enclosed in either single or double quotes.

JUS[TIFY] (LEFT | CENTER | CENTRE | RIGHT)

Controls where the heading text prints relative to the column width. By default, headings for numeric fields print flush right, and headings for text fields print flush ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page