A SQL*Loader Syntax Diagrams
This appendix describes SQL*Loader syntax in graphic form (sometimes called railroad diagrams or DDL diagrams).
For information about the syntax notation used, see the Oracle Database SQL Language Reference
The following diagrams are shown with certain clauses collapsed (such as pos_spec). These diagrams are expanded and explained further along in the appendix.
Options Clause
Options_Cont
Load Statement
infile_clause
Note:
On the BADFILE and DISCARDFILE clauses, you must specify either a directory path, or a filename, or both.
concatenate_clause
into_table_clause
into_table_clause_continued
field_condition
full_fieldname
termination_spec
enclosure_spec
xmltype_spec
dgen_fld_spec
init_spec
bfile_spec
filler_fld_spec
scalar_fld_spec
lobfile_spec
lls_field_spec
datatype_spec
datatype_spec_cont
col_obj_fld_spec
collection_fld_spec
nested_table_spec
varray_spec
count_spec
