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.
Description of the illustration ''options.gif''
Description of the illustration ''load_statement.gif''
Description of the illustration ''infile_clause.gif''
Description of the illustration ''concatenate.gif''
Description of the illustration ''intotab_clause.gif''
Description of the illustration ''fld_cond.gif''
Description of the illustration ''delim_spec.gif''
Description of the illustration ''fieldname.gif''
Description of the illustration ''terminat.gif''
Description of the illustration ''enclose.gif''
Description of the illustration ''oid_spec.gif''
Description of the illustration ''sid_spec.gif''
Description of the illustration ''xmltype_spec.gif''
Description of the illustration ''field_list.gif''
Description of the illustration ''dgen_fld.gif''
Description of the illustration ''ref.gif''
Description of the illustration ''init.gif''
Description of the illustration ''bfile.gif''
Description of the illustration ''filler_fld.gif''
Description of the illustration ''scalar.gif''
Description of the illustration ''lobfile_spec.gif''
Description of the illustration ''pos_spec.gif''
Description of the illustration ''datatype_spec.gif''
Description of the illustration ''datatype_spec_cont.gif''
Description of the illustration ''col_obj_fld_spec.gif''
Description of the illustration ''coll_fld.gif''
Description of the illustration ''nested_table.gif''
Description of the illustration ''varray.gif''
Description of the illustration ''sdf.gif''
Description of the illustration ''count.gif''