DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: what is the difference between these 2 number fields

  1. 05-29-2003, 11:16 AM #1
    badrinathn
    badrinathn is offline Advisor
    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.
    Reply With Quote Reply With Quote
  2. 05-29-2003, 11:20 AM #2
    badrinathn
    badrinathn is offline Advisor
    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.
    Reply With Quote Reply With Quote
  3. 05-29-2003, 11:55 AM #3
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    I like these self-answering forums!
    Reply With Quote Reply With Quote
  4. 05-29-2003, 11:59 AM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Hmmmm, someone is wide open here, and it ain't me!

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  5. 05-29-2003, 12:16 PM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I was trying to decide if I would reply "RTFM" or "1" but he beat me to it...
    Jeff Hunter
    Reply With Quote Reply With Quote
  6. 05-29-2003, 01:38 PM #6
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    I was going for 1.
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  7. 05-29-2003, 02:30 PM #7
    sysdba
    sysdba is offline Senior Member
    Join Date
    Jun 2000
    Posts
    295
    RTFM stands for:
    Read The F*** Manual?
    Reply With Quote Reply With Quote
  8. 05-29-2003, 10:23 PM #8
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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