A SQL*Loader Syntax Diagrams
This appendix describes SQL*Loader syntax in graphic form (sometimes called railroad diagrams or DDL diagrams).
How to Read Graphic Syntax Diagrams
Syntax diagrams are drawings that illustrate valid SQL syntax. To read a diagram, trace it from left to right, in the direction shown by the arrows.
For more information about standard SQL syntax notation, see:
How to Read Syntax Diagrams in 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
