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

column_name

Name of the database column into which you want data for the field to be loaded.

[BOUND] FILLER

Indicates that a field in the INFILE is not loaded into the target table. This keyword was introduced with Oracle8i. A bound filler field, new in Oracle9i, is a filler field that can be used with the NULLIF or DEFAULTIF clauses.

generated

Causes SQL*Loader to use a generated value for the field. The options for generation are:

RECNUM

The record number for the record

SYSDATECONSTANT “string”SEQUENCE

Similar to RECNUM, but does not include a sequence number for bad records. The SEQUENCE specification can include the following: the keyword COUNT, which starts the sequence with a number higher than the count of the records already in the table; the keyword MAX, which starts the sequence with the integer higher than the maximum value of the column; an integer, which is the integer with which to start the sequence; and an increment, which is a positive integer greater than 1, indicating how the sequence should be incremented for each record.

start | *

Starting position of the field in the input record. The first byte is position one. Using * in this position indicates that this field starts immediately after the previous field or with the first byte of the record for the first field.

offset

Optional offset that you can have SQL*Loader add to the position represented by the * character.

end

Position of the last byte of data in the field. This is optional. If you omit the ending ...

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