1. Chapter 1 Introduction to SQL*Loader

   1. The SQL*Loader Environment

   2. A Short SQL*Loader Example

   3. SQL*Loader's Capabilities

   4. Issues when Loading Data

   5. Invoking SQL*Loader

2. Chapter 2 The Mysterious Control File

   1. Syntax Rules

   2. The LOAD Statement

   3. Command-Line Parameters in the Control File

   4. Placing Data in the Control File

3. Chapter 3 Fields and Datatypes

   1. Field Specifications

   2. Datatypes

4. Chapter 4 Loading from Fixed-Width Files

   1. Common Datatypes Encountered

   2. Specifying Field Positions

   3. Handling Anomalous Data

   4. Concatenating Records

   5. Nesting Delimited Fields

5. Chapter 5 Loading Delimited Data

   1. Common Datatypes Encountered

   2. Example Data

   3. Using Delimiters to Identify Fields

   4. Common Issues with Delimited Data

   5. Concatenating Records

   6. Handling Nested Fields

6. Chapter 6 Recovering from Failure

   1. Deleting and Starting Over

   2. Restarting a Conventional Path Load

   3. Restarting a Direct Path Load

7. Chapter 7 Validating and Selectively Loading Data

   1. Handling Rejected Records

   2. Selectively Loading Data

8. Chapter 8 Transforming Data During a Load

   1. Using Oracle's Built-in SQL Functions

   2. Writing Your Own Functions

   3. Passing Data Through Work Tables

   4. Using Triggers

   5. Performing Character Set Conversion

9. Chapter 9 Transaction Size and Performance Issues

   1. Transaction Processing in SQL*Loader

   2. Commit Frequency and Load Performance

   3. Commit Frequency and Rollback Segments

   4. Performance Improvement Guidelines

10. Chapter 10 Direct Path Loads

    1. What is the Direct Path?

    2. Performing Direct Path Loads

    3. Data Saves

    4. Loading Data Fields Greater than 64K

    5. UNRECOVERABLE Loads

    6. Parallel Data Loading

11. Chapter 11 Loading Large Objects

    1. About Large Objects

    2. Considerations when Loading LOBs

    3. Loading Inline LOBs

    4. Loading LOBs from External Data Files

    5. Loading BFILEs

12. Chapter 12 Loading Objects and Collections

    1. Loading Object Tables and Columns

    2. Loading Collections

    3. Using NULLIF and DEFAULTIF with an Object or a Collection

1. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Oracle SQL*Loader: The Definitive Guide is a scarab beetle. There are nearly 30,000 members of the scarab beetle family, and over 1,200 in North America alone. This large, heavy-bodied beetle is classified in the order Coleoptera, family Scarabaeidae. Many scarab beetles are brightly colored, and some are iridescent. In North America, the largest scarabs are the Hercules beetle and the closely related elephant and rhinoceros beetles. The males of these species have prominent horns.

Many scarabs are scavengers, living on decaying vegetation and animal dung. They are consider efficient recyclers and valuable for reducing disease-breeding waste. Some of the scavengers of the scarab family use their front legs to gather dung and roll it into a ball. They carry the ball underground and use it as food and a place to lay their eggs. The Mediterranean black scarab's apparently magical ability to reproduce from mud and decaying organic materials led the ancient Egyptians to associate the scarab with resurrection and immortality. The beetles were considered sacred, and representations in stone and metal were buried with mummies.

A member of the North American scarab family plays a key role in Edgar Allen Poe's story "The Gold-Bug." In his search of Sullivan's Island, South Carolina, a scarab beetle is William Legrand's mysterious guide to the buried treasure of Captian Kidd. Colleen Gorman was the production editor and the copyeditor for Oracle SQL*Loader: The Definitive Guide. Sarah Jane Shangraw and Linley Dolby provided quality control, and Leanne Soylemez was the proofreader. John Bickelhaupt wrote the index.

Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is from Cuvier's Animals. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.

Melanie Wang designed the interior layout based on a series design by Nancy Priest. Anne-Marie Vaduva converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book; the code font is Constant Willison. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. This colophon was written by Colleen Gorman.