SUTIL050

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.

SUTIL3719Options Clause

Description of the illustration options.gif

SUTIL3720Load Statement

Description of the illustration load_statement.gif

SUTIL3721infile_clause

Description of the illustration infile_clause.gif

SUTIL3722concatenate_clause

Description of the illustration concatenate.gif

SUTIL3723into_table_clause

Description of the illustration intotab_clause.gif

SUTIL3724field_condition

Description of the illustration fld_cond.gif

SUTIL3725delim_spec

Description of the illustration delim_spec.gif

SUTIL3726full_fieldname

Description of the illustration fieldname.gif

SUTIL3727termination_spec

Description of the illustration terminat.gif

SUTIL3728enclosure_spec

Description of the illustration enclose.gif

SUTIL3729oid_spec

Description of the illustration oid_spec.gif

SUTIL3730sid_spec

Description of the illustration sid_spec.gif

SUTIL3731xmltype_spec

Description of the illustration xmltype_spec.gif

SUTIL3732field_list

Description of the illustration field_list.gif

SUTIL3733dgen_fld_spec

Description of the illustration dgen_fld.gif

SUTIL3734ref_spec

Description of the illustration ref.gif

SUTIL3735init_spec

Description of the illustration init.gif

SUTIL3736bfile_spec

Description of the illustration bfile.gif

SUTIL3737filler_fld_spec

Description of the illustration filler_fld.gif

SUTIL3738scalar_fld_spec

Description of the illustration scalar.gif

SUTIL3739lobfile_spec

Description of the illustration lobfile_spec.gif

SUTIL3740pos_spec

Description of the illustration pos_spec.gif

SUTIL3741datatype_spec

Description of the illustration datatype_spec.gif

SUTIL3742datatype_spec_cont

Description of the illustration datatype_spec_cont.gif

SUTIL3743col_obj_fld_spec

Description of the illustration col_obj_fld_spec.gif

SUTIL3744collection_fld_spec

Description of the illustration coll_fld.gif

SUTIL3745nested_table_spec

Description of the illustration nested_table.gif

SUTIL3746varray_spec

Description of the illustration varray.gif

SUTIL3747sdf_spec

Description of the illustration sdf.gif

SUTIL3748count_spec

Description of the illustration count.gif