Bind Arrays and Conventional Path Loads.

These sections describe the benefits of using multiple INTO TABLE clauses.

Benefits of Using Multiple INTO TABLE Clauses.

This section describes loading logical records into tables.

This section describes assembling logical records from physical records.

Assembling Logical Records from Physical Records.

Loads are interrupted and discontinued for several reasons. SQL*Loader supports different character encoding schemes (called character sets, or code pages).

Handling Different Character Encoding Schemes.

You can specify certain datetime formats at the table level in a SQL*Loader control file.

Specifying Datetime Formats At the Table Level.

You can specify a NULLIF clause at the table level.

Specifying a NULLIF Clause At the Table Level.

When SQL*Loader executes, it can create a file called a bad file or reject file in which it places records that were rejected because of formatting errors or because they caused Oracle errors.ĭuring execution, SQL*Loader can create a discard file for records that do not meet any of the loading criteria. When configuring SQL*Loader, you can specify an operating system-dependent file processing options string ( os_file_proc_clause) in the control file to specify file format and buffering.

Specifying Data File Format and Buffering.

Specify the BEGINDATA statement before the first data record.

Identifying Data in the Control File with BEGINDATA.

To direct SQL*Loader to access the data files as comma-separated-values format files, use the CSV clause. To specify a data file that contains the data to be loaded, use the INFILE keyword, followed by the file name and optional file processing options string. You can use the FIELD NAMES clause in the SQL*Loader control file to specify field order.

The XMLTYPE clause is available for use in a SQL*Loader control file. In general, SQL*Loader follows the SQL standard for specifying object names (for example, table and column names). You can specify command-line parameters in the SQL*Loader control file using the OPTIONS clause. Specifying Command-Line Parameters in the Control File.The SQL*Loader control file is a text file that contains data definition language (DDL) instructions.

Sqlldr control file example