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.
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.
You can change column values.
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).
Glossary, Variables in the Documentation