A
SQL*Loader Syntax Diagrams

The SQL*Loader DDL diagrams (sometimes called railroad diagrams) use standard SQL syntax notation. For more information about the syntax notation used in this appendix, see the PL/SQL User's Guide and Reference and the Oracle9i 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

Text description of the illustration options.gif

Load Statement

Text description of the illustration load.gif

Text description of the illustration load2.gif

Text description of the illustration load3.gif

Text description of the illustration load4.gif

Text description of the illustration load5.gif

infile_clause

Text description of the illustration infile.gif

Text description of the illustration infile2.gif

os_file_proc_clause

Text description of the illustration os_file.gif

concatenate_clause

Text description of the illustration concat.gif

into_table_clause

Text description of the illustration intotab.gif

Text description of the illustration intotab2.gif

Text description of the illustration intotab3.gif

Text description of the illustration intotab4.gif

Text description of the illustration intotab5.gif

Text description of the illustration intotab6.gif

Text description of the illustration intotab7.gif

Text description of the illustration intotab8.gif

field_condition

Text description of the illustration fld_cond.gif

delim_spec

Text description of the illustration delim.gif

full_fieldname

Text description of the illustration fld_name.gif

termination_spec

Text description of the illustration terminat.gif

enclosure_spec

Text description of the illustration enclose.gif

oid_spec

Text description of the illustration oid_spec.gif

sid_spec

Text description of the illustration sid_spec.gif

field_list

Text description of the illustration fld_list.gif

d_gen_fld_spec

Text description of the illustration dgen_fld.gif

ref_spec

Text description of the illustration ref.gif

init_spec

Text description of the illustration init.gif

bfile_spec

Text description of the illustration bfile.gif

filler_fld_spec

Text description of the illustration fill_fld.gif

scalar_fld_spec

Text description of the illustration scalar.gif

Text description of the illustration scalar2.gif

lobfile_spec

Text description of the illustration lobfile.gif

Text description of the illustration lobfile2.gif

Text description of the illustration lobfile3.gif

pos_spec

Text description of the illustration pos_spec.gif

datatype_spec

The syntax for datatype_spec is as follows:

Text description of the illustration datatype.gif

col_obj_fld_spec

Text description of the illustration col_obj_fld_spec.gif

collection_fld_spec

Text description of the illustration coll_fld.gif

nested_table_spec

Text description of the illustration nest_tab.gif

varray_spec

Text description of the illustration varray.gif

sdf_spec

Text description of the illustration sdf.gif

Text description of the illustration sdf2.gif

Text description of the illustration sdf3.gif

count_spec

Text description of the illustration count.gif