A SQL*Loader Syntax Diagrams
The SQL*Loader syntax diagrams (sometimes called railroad diagrams or DDL diagrams) use standard SQL syntax notation. For more information about the syntax notation used in this appendix, see the Oracle Database SQL Reference.
The following diagrams of DDL syntax are shown with certain clauses collapsed (such as pos_spec). These diagrams are expanded and explained further along in the appendix.
Options Clause
Description of the illustration options.gif
Load Statement
Description of the illustration load_statement.gif
infile_clause
Description of the illustration infile_clause.gif
concatenate_clause
Description of the illustration concatenate.gif
into_table_clause
Description of the illustration intotab_clause.gif
field_condition
Description of the illustration fld_cond.gif
delim_spec
Description of the illustration delim_spec.gif
full_fieldname
Description of the illustration fieldname.gif
termination_spec
Description of the illustration terminat.gif
enclosure_spec
Description of the illustration enclose.gif
oid_spec
Description of the illustration oid_spec.gif
sid_spec
Description of the illustration sid_spec.gif
field_list
Description of the illustration field_list.gif
dgen_fld_spec
Description of the illustration dgen_fld.gif
Description of the illustration ref.gif
init_spec
Description of the illustration init.gif
bfile_spec
Description of the illustration bfile.gif
filler_fld_spec
Description of the illustration filler_fld.gif
scalar_fld_spec
Description of the illustration scalar.gif
Description of the illustration lobfile_spec.gif
pos_spec
Description of the illustration pos_spec.gif
Description of the illustration datatype_spec.gif
datatype_spec_cont
Description of the illustration datatype_spec_cont.gif
col_obj_fld_spec
Description of the illustration col_obj_fld_spec.gif
collection_fld_spec
Description of the illustration coll_fld.gif
nested_table_spec
Description of the illustration nested_table.gif
varray_spec
Description of the illustration varray.gif
Description of the illustration sdf.gif
Description of the illustration count.gif