I am trying to load a numeric data which comes in the scientific notation using sqlloader.
My table has a std_cost which is Number (10,3). The scientific number is 1.202E007 (which is equivalent to 12020000) and the length is just 8.
If I load this data to my table (into number(10,3) field) it fails with
ORA-01438: value larger than specified precision allows for this column
However, If I increase the field length of std_cost to number(11,3) the load is succesful.
Could you please tell me what is the difference here.