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

Keywords

datatype_name

Name of one of the datatypes described later. Different datatype clauses apply to different datatypes. Two parts of the datatype clause are common across multiple datatypes: enclosure and termination.

enclosure

The syntax for this clause is:

[OPTIONAL] ENCLOSED [BY] ['string' | X'hex_value'] [AND 'string' |
   X'hex_value']

You can also use the OPTIONAL keyword to indicate that the enclosing characters are optional, but only following the TERMINATED BY clause. The AND keyword indicates a different ending character from the initial character.

termination

The syntax for this clause is:

{DELIMITED [BY]}|{TERMINATED [BY]} WHITESPACE|X'hex_value' |
   'string' | EOF

where WHITESPACE indicates that the termination of the field is any type of whitespace, including space characters, tab characters, and newline characters. EOF stands for end-of-file, and is primarily used for loading LOBs.

The datatype_names and their syntax are:

CHAR length 
                              enclosure 
                              termination
DATE length 
                              mask 
                              enclosure 
                              termination

where mask is the date mask used by the Oracle TO_DATE function to convert the incoming date.

{INTEGER | DECIMAL | FLOAT | ZONED} [EXTERNAL]
 length 
                              enclosure 
                              termination
GRAPHIC [EXTERNAL] length

where length is the length of the raw graphic file in terms of double bytes. The EXTERNAL keyword indicates that the graphic is enclosed by shift-in and shift-out characters.

RAW length
VARCHARC | VARRAWC (length[,max_bytes])

For these datatypes, the length of the field is indicated in the first ...

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