what is the difference between these 2 number fields

Hi,

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.

Badrinath

Ok- Guys I got it-
10,3 can take only 7 digits...thanks

I like these self-answering forums!

Hmmmm, someone is wide open here, and it ain't me!

MH
:D

I was trying to decide if I would reply "RTFM" or "1" but he beat me to it...

I was going for 1.

RTFM stands for:
Read The F*** Manual?

Quote:

---

Originally posted by sysdba
RTFM stands for:
Read The F*** Manual?

---

STFW