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

Description of the illustration options.eps follows
Description of the illustration options.eps

Load Statement

Description of the illustration load_statement.eps follows
Description of the illustration load_statement.eps

infile_clause

Description of the illustration infile_clause.eps follows
Description of the illustration infile_clause.eps

Note:

On the BADFILE and DISCARDFILE clauses you must specify either a directory path or a filename, or both.

concatenate_clause

Description of the illustration concatenate.eps follows
Description of the illustration concatenate.eps

into_table_clause

Description of the illustration intotab_clause.eps follows
Description of the illustration intotab_clause.eps

into_table_clause_continued

Description of the illustration intotab_clause_cont.eps follows
Description of the illustration intotab_clause_cont.eps

field_condition

Description of the illustration fld_cond.eps follows
Description of the illustration fld_cond.eps

delim_spec

Description of the illustration delim_spec.eps follows
Description of the illustration delim_spec.eps

full_fieldname

Description of the illustration fieldname.eps follows
Description of the illustration fieldname.eps

termination_spec

Description of the illustration terminat.eps follows
Description of the illustration terminat.eps

enclosure_spec

Description of the illustration enclose.eps follows
Description of the illustration enclose.eps

oid_spec

Description of the illustration oid_spec.eps follows
Description of the illustration oid_spec.eps

sid_spec

Description of the illustration sid_spec.eps follows
Description of the illustration sid_spec.eps

xmltype_spec

Description of the illustration xmltype_spec.eps follows
Description of the illustration xmltype_spec.eps

field_list

Description of the illustration field_list.eps follows
Description of the illustration field_list.eps

dgen_fld_spec

Description of the illustration dgen_fld.eps follows
Description of the illustration dgen_fld.eps

ref_spec

Description of the illustration ref.eps follows
Description of the illustration ref.eps

init_spec

Description of the illustration init.eps follows
Description of the illustration init.eps

bfile_spec

Description of the illustration bfile.eps follows
Description of the illustration bfile.eps

filler_fld_spec

Description of the illustration filler_fld.eps follows
Description of the illustration filler_fld.eps

scalar_fld_spec

Description of the illustration scalar.eps follows
Description of the illustration scalar.eps

lobfile_spec

Description of the illustration lobfile_spec.eps follows
Description of the illustration lobfile_spec.eps

pos_spec

Description of the illustration pos_spec.eps follows
Description of the illustration pos_spec.eps

datatype_spec

Description of the illustration datatype_spec.eps follows
Description of the illustration datatype_spec.eps

datatype_spec_cont

Description of the illustration datatype_spec_cont.eps follows
Description of the illustration datatype_spec_cont.eps

col_obj_fld_spec

Description of the illustration col_obj_fld_spec.eps follows
Description of the illustration col_obj_fld_spec.eps

collection_fld_spec

Description of the illustration coll_fld.eps follows
Description of the illustration coll_fld.eps

nested_table_spec

Description of the illustration nested_table.eps follows
Description of the illustration nested_table.eps

varray_spec

Description of the illustration varray.eps follows
Description of the illustration varray.eps

sdf_spec

Description of the illustration sdf.eps follows
Description of the illustration sdf.eps

count_spec

Description of the illustration count.eps follows
Description of the illustration count.eps