Skip Headers

Oracle® Database Utilities
10g Release 1 (10.1)

Part Number B10825-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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 options.gif follows
Description of the illustration options.gif


Load Statement
Description of load_statement.gif follows
Description of the illustration load_statement.gif


infile_clause
Description of infile_clause.gif follows
Description of the illustration infile_clause.gif


concatenate_clause
Description of concatenate.gif follows
Description of the illustration concatenate.gif


into_table_clause
Description of intotab_clause.gif follows
Description of the illustration intotab_clause.gif


field_condition
Description of fld_cond.gif follows
Description of the illustration fld_cond.gif


delim_spec
Description of delim_spec.gif follows
Description of the illustration delim_spec.gif


full_fieldname
Description of fieldname.gif follows
Description of the illustration fieldname.gif


termination_spec
Description of terminat.gif follows
Description of the illustration terminat.gif


enclosure_spec
Description of enclose.gif follows
Description of the illustration enclose.gif


oid_spec
Description of oid_spec.gif follows
Description of the illustration oid_spec.gif


sid_spec
Description of sid_spec.gif follows
Description of the illustration sid_spec.gif


field_list
Description of field_list.gif follows
Description of the illustration field_list.gif


dgen_fld_spec
Description of dgen_fld.gif follows
Description of the illustration dgen_fld.gif


ref_spec
Description of ref.gif follows
Description of the illustration ref.gif


init_spec
Description of init.gif follows
Description of the illustration init.gif


bfile_spec
Description of bfile.gif follows
Description of the illustration bfile.gif


filler_fld_spec
Description of filler_fld.gif follows
Description of the illustration filler_fld.gif


scalar_fld_spec
Description of scalar.gif follows
Description of the illustration scalar.gif


lobfile_spec
Description of lobfile_spec.gif follows
Description of the illustration lobfile_spec.gif


pos_spec
Description of pos_spec.gif follows
Description of the illustration pos_spec.gif


datatype_spec
Description of datatype_spec.gif follows
Description of the illustration datatype_spec.gif


datatype_spec_cont
Description of datatype_spec_cont.gif follows
Description of the illustration datatype_spec_cont.gif


col_obj_fld_spec
Description of col_obj_fld_spec.gif follows
Description of the illustration col_obj_fld_spec.gif


collection_fld_spec
Description of coll_fld.gif follows
Description of the illustration coll_fld.gif


nested_table_spec
Description of nested_table.gif follows
Description of the illustration nested_table.gif


varray_spec
Description of varray.gif follows
Description of the illustration varray.gif


sdf_spec
Description of sdf.gif follows
Description of the illustration sdf.gif


count_spec
Description of count.gif follows
Description of the illustration count.gif