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

Concatenation Clauses

Concatenation rules tell SQL*Loader to combine two or more records from the INFILE into a single row in the database. You can specify concatenation in two ways. The first way is with the CONCATENATE clause:

CONCATENATE record_number

where record_number indicates a fixed number of records in the INFILE. The second is with the CONTINUEIF clause.

The THIS keyword indicates that the continuation character is in the current record. The NEXT keyword indicates that the continuation character is in the next record, which will be concatenated to this record. The PRESERVE keyword indicates that the continuation character(s) are preserved in the data loaded. The PRESERVE keyword was new in Oracle8i. The remainder of the clause is used to identify the position and value of the continuation characters.

An alternative syntax for the CONTINUEIF clause for non-fixed length is:

CONTINUEIF LAST [(]{= | <>}{'char' | X'hex_digits'}[)]

which tells SQL*Loader to check the last character in the record for a continuation character. With this syntax, the continuation character is always preserved in the row.

If you use concatenation, the position information for the fields refers to the combined row.

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