what is the difference between these 2 number fields
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: what is the difference between these 2 number fields

  1. #1
    Join Date
    Jan 2001
    Posts
    642

    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.

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    Ok- Guys I got it-
    10,3 can take only 7 digits...thanks
    There is always a better way to do the things.

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    I like these self-answering forums!

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Hmmmm, someone is wide open here, and it ain't me!

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I was trying to decide if I would reply "RTFM" or "1" but he beat me to it...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    I was going for 1.
    I remember when this place was cool.

  7. #7
    Join Date
    Jun 2000
    Posts
    295
    RTFM stands for:
    Read The F*** Manual?

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
  •  



Click Here to Expand Forum to Full Width