ORACLE (DELIMITED) (.009)    FOREIGN FORMAT (.44)

Name Value
NAME ORACLE (DELIMITED)
FIELD DELIMITER ,
SEND LAST FIELD DELIMITER? YES
FILE HEADER D ORACTL^DDXPLIB
DESCRIPTION
Use this format to export data to an Oracle table.  Data will be exported
in comma-delimited format and non-numeric fields will be surrounded by
quotes.  The user will be prompted for field names.  The field names
should be the column_names in the Oracle table.  Also, the user will need
to supply the maximum length of a record to be exported.  By default, data
will be imported into a table with the same name as that of the export
template.
USAGE NOTES
This format produces a control file to be used with Oracle's SQL*LOADER
 |TAB|
       SQLLOAD USERID=username/password, CONTROL=INTO_ORACLE.CTL|TAB|
 
Of course, other options are available.  Consult your Oracle documentation.
utility to load data into a preexisting Oracle table.  The control file is
complete as created, but you may edit the file to modify the import.  By
default, the data will be imported into a table with the same name as that
of the export template.  So, either that table must exist in your Oracle
table_space with the columns specified when the export template was built
or the exported file will need to be modified to show the correct
table_name.  A minimum syntax for loading an export file named
INTO_ORACLE.CTL would be:
FORMAT USED? YES
RECORD LENGTH FIXED? NO
NEED FOREIGN FIELD NAMES? YES
MAXIMUM OUTPUT LENGTH 0
QUOTE NON-NUMERIC FIELDS? YES