If the data is included in the control file itself, then the INFILE
clause is followed by an asterisk rather than a file name. The actual data is placed in the control file after the load configuration specifications.
Specify the BEGINDATA
statement before the first data record. The syntax is:
BEGINDATA
first_data_record
Keep the following points in mind when using the BEGINDATA
statement:
If you omit the BEGINDATA
statement but include data in the control file, then SQL*Loader tries to interpret your data as control information and issues an error message. If your data is in a separate file, then do not use the BEGINDATA
statement.
Do not use spaces or other characters on the same line as the BEGINDATA
statement, or the line containing BEGINDATA
will be interpreted as the first line of data.
Do not put comments after BEGINDATA,
or they will also be interpreted as data.
"Specifying Data Files" for an explanation of using INFILE
Case study 1, Loading Variable-Length Data (see "SQL*Loader Case Studies" for information on how to access case studies)