Results 1 to 4 of 4

Thread: Numeric Data

  1. #1
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Numeric Data

    I created a table for testing purpose
    create table xx (a number)

    inserting 38 digit number
    insert into xx values(11111111111111111111111111111111111111)

    inserting 39 digit number
    insert into xx values(111111111111111111111111111111111111111)

    inserting 126 digit number
    insert into xx values(1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111)

    if i try to insert 127 digit number then it is showing message ora - 01426 numeric overflow.

    Precision for oracle numeric data is 38 only. How it is accepting a numeric value upto 126 digits?

    Last edited by krishnaindia2007; 02-23-2008 at 07:51 AM.

  2. #2
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Numeric Data

    For Example ,if precision is defined
    create table xx (a number(38))
    ----
    inserting 39 digit number
    insert into xx values(111111111111111111111111111111111111111)
    then it will return error ora-01438
    -----

    if not defined then
    the precision is the maximum number of significant decimal digits i.e 126 binary digits


  3. #3
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Numeric Data

    Whether numeric datatype is fixed length datatype or variable length datatype? i.e. Whether if takes fixed length irrespective of value we stored just like char datatype or it takes space depending on the value we stored?


  4. #4
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Numeric Data

    I found answer. Numbers in an oracle database are always stored as variable length data.

    Last edited by krishnaindia2007; 02-26-2008 at 01:14 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact