-
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
There is always a better way to do the things.
-
Ok- Guys I got it-
10,3 can take only 7 digits...thanks
There is always a better way to do the things.
-
I like these self-answering forums!
-
Hmmmm, someone is wide open here, and it ain't me!
MH
I remember when this place was cool.
-
I was trying to decide if I would reply "RTFM" or "1" but he beat me to it...
Jeff Hunter
-
I remember when this place was cool.
-
RTFM stands for:
Read The F*** Manual?
-
Originally posted by sysdba
RTFM stands for:
Read The F*** Manual?
STFW
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|