Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    17

    Unanswered: Column max value

    Hello!

    I need to find out which is the maximum value that a NUMBER column can accept. For example, I have to interact with a table that has a NUMBER(20,4) column, and I'd like to catch the "exceeds precision" error by comparing the value to insert with the max value that the column can hold.

    Thanks in advance,

    Mike

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I'd like to catch the "exceeds precision" error by comparing the value to insert with the max value that the column can hold.
    Which Oracle version to 4 decimal places?
    In which language are you writing your code?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2004
    Posts
    17
    Oracle 9i, Visual Basic 6

    Thanks in advance,

    Mike

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >>Which Oracle version to 4 decimal places?
    >Oracle 9i,
    Somebody need remedial counting training.

    query DBA|ALL|USER|_TAB_COLUMNS
    but I am willing to bet that in all cases "value" > "max value" so I am not clear what is going to be gained by this exercise.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2004
    Posts
    17
    I agree, in all cases "value" > "max value". What I'd like to obtain is the greatest value a number column may hold, for a given precision and scale. That does not depend on the programming language.

    Best regards,

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •