Function documentationImporting: Loader Commands Locate this document in the navigation structure

 

Loader can process a range of Loader commands and SQL statements, including Loader-specific commands for importing data.

Prerequisites

Calling the Loader

Opening a Session: Loader Commands

Exporting: Loader Commands

Features

Syntax Syntax

  1. <import_command> ::=
  <import_db_command>
| <import_user_command>
| <import_schema_command>
| <import_table_command>
| <import_columns_command>
End of the code.

The range of Loader commands enables you to import a complete database or part of a complete database, such as, database user objects, schema objects, data from a table, or a set of column values from a table.

Example

Loader Tutorial, Importing

More Information

UPDATE COLUMNS Command

Syntax Rules: Sorted Alphabetically

Syntax Rules: Sorted Semantically

Loader Commands and SQL Statements