Skip Headers
Oracle® Database Utilities
11g Release 1 (11.1)

Part Number B28319-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
Contact Us

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

A SQL*Loader Syntax Diagrams

This appendix provides descriptions of 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 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

xmltype_spec

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