The Loader can execute commands and SQL statements.
You can execute the commands and SQL statements for importing and exporting data only after you have successfully started a database session. This ensures that only suitably authorized owners can import and export.
See also:
Creating a Database Session: Commands
One of the main functions of the Loader is the exporting and importing of the database catalog, parts of the database catalog and application data. A range of commands and associated syntax elements are available for this purpose.
See also:
You can change column values.
See also:
The Loader can execute the SQL statements required for exporting and importing. DDL statements, in particular, are vital for importing data (SQL Reference Manual: SQL Statements: Overview).
Database queries, however, return only status messages.
COMMIT and ROLLBACK statements are only active in the mode AUTOCOMMIT OFF (AUTOCOMMIT Command).
See also:
Glossary, Variables in the Documentation