How to define Number(20,6) in control file ?
Only "Decimal External" works without any scale and precision but when i tried "Decimal External(20,6)" , it throws exception. I want to mention both scale and precision.
Can anyone help?
Because i want the load to fail if data file has incorrect data.
Table has column
and my control file has corresponding definition as
DAILY_QUANTITY DECIMAL EXTERNAL
Which works fine BUT i also want to specify scale/precision.
Pl post exact OS and database versions, along with the complete sqlldr command used, the contents of the control file and log file, a description of the table, and a few sample rows of data. How is the data file being generated ?