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

Common Keywords and Clauses

You can specify the following keywords in calling many of the functions described in this chapter:

ASC

Specifies that the ordering sequence should be ascending.

DESC

Specifies that the ordering sequence should be descending.

dfmt

Specifies a date format specification made up of the elements shown in Appendix D.

fmt

Specifies a numeric format specification made up of the elements shown in Appendix C

nlsparams

Specifies a character string made up of one or more of the following elements, allowing you to specify various National Language Support (NLS) characteristics for the result:

NLS_NUMERIC_CHARACTERS = ''dg''

Allows you to specify the characters to use for decimal points, d, and group separators, g. You also must use D and G in your format specification to mark the location of the decimal point and group separators.

NLS_CURRENCY = ''text''

Allows you to specify the currency symbol (up to 10 characters long) to use in place of any L characters contained in the format specification.

NLS_ISO_CURRENCY = ''territory''

Allows you to specify the NLS territory whose currency symbol you want to use in place of any C characters contained in the format specification.

The nlsparams settings are strings embedded within a string. Note that the quotes in this clause are doubled single quotes, not double quotes.

nlsdateparam

Specifies a string in the form NLS_DATE_LANGUAGE = langname, where langname represents a valid NLS language name. The NLS language name affects ...

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