The LOAD and UNLOAD instructions

Informix® provides two SQL instructions to export / import data from / into a database table: The UNLOAD instruction copies rows from a database table into a text file and the LOAD instructions insert rows from a text file into a database table.

ORACLE does not provide LOAD and UNLOAD instructions, but provides external tools like SQL*Plus and SQL*Loader.

Solution

In 4gl programs, the LOAD and UNLOAD instructions are supported with ORACLE, with some limitations: