SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / BDL programming |
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.
In 4gl programs, the LOAD and UNLOAD instructions are supported with ORACLE, with some limitations:
The same problem appears for Informix INTEGER and SMALLINT values, which are stored in an ORACLE database as NUMBER(?) columns. Those values will be unloaded as Informix DECIMAL(10) and DECIMAL(5) values, that is, with a trailing dot-zero ".0".