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


ref_spec

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


lobfile_spec

Description of the illustration lobfile_spec.gif


pos_spec

Description of the illustration pos_spec.gif


datatype_spec

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


sdf_spec

Description of the illustration sdf.gif


count_spec

Description of the illustration count.gif