SQL *Loader Log File
February 15, 2007 by Mark Marucot · Leave a Comment
Every loading execution of SQL *Loader, a log file is created. The log file contains the detailed summary of the loading and description of errors encountered.
Syntax
-
logfile
SQL *Loader Field Condition Clause
February 15, 2007 by Mark Marucot · Leave a Comment
A field condition is a statement about a field in a logical record that evaluates as true or false. It is used in the NULLIF and DEFAULTIF clauses, as well as in the WHEN clause. This is also the same with CONTINUEIF clause.
Parameters for the Field Condition Clause
os_spec
Specifies the starting and ending position of the comparison field in the logical record. It must be surrounded by parentheses. Either start-end or start:end is acceptable.
The starting location can be specified as a column number, or as * (next column), or as *+n (next column plus an offset).
