December 2002
Intermediate to advanced
928 pages
85h 29m
English
For collections, you use the following syntax:
column_name{VARRAY | NESTED TABLE |secondary_data_file} {COUNT(fieldname) | COUNT(CONSTANTinteger)
where COUNT is the number of items in the collection and fieldname is the name of a field in the INFILE that contains that count. The secondary_data_file is the name of an external file that holds the collection with the following syntax:
SDF({fieldname|CONSTANT 'file_name'}) os_specific_options
[MAXRECORDSIZE bytes] [CHARACTERSET 'charsetname']where fieldname is the name of a field in the INFILE that contains the name of the external file. For information on os_specific_options, see the Oracle documentation for your specific platform.