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

Thread: numeric data type

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Unhappy

    can some one please tell me the differences between these 3 numeric data types?

    number(6)
    number
    number(6,4)

  2. #2
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    number(6) = Rows can only be between 0 - 100000
    number = unlimited rows without decimals
    number(6,4) = up to 100000 with four decimals but it is much better as number(6,2)
    I hope this helps you.

    C.K.
    Apps DBA

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by cekeke
    number(6,4) = up to 100000 with four decimals but it is much better as number(6,2)
    I hope this helps you.

    C.K.
    Apps DBA [/B]
    :-) For how long time have you been using Oracle?

    Because from your answer above, somebody could get the impression that you can store 999999 into a number(6,4) field.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Jun 2001
    Posts
    132
    :-) For how long time have you been using Oracle?


    I don't think you have to insult him by saying this. he's trying to help, if he's wrong just correct him. Besides, you've had some mistakes here yourself.
    You think I'm going to have an affair with you? --Stanley Kowalski

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by julian
    from your answer above, somebody could get the impression that you can store 999999 into a number(6,4) field.
    Hardly. One should have a wild immagination to get the impression that 999999 can be stored into a number that was defined as "can stored values up to 100000 " (as defined by cekeke).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87
    number(6) = Rows can only be between 0 - 100000
    number = unlimited rows without decimals
    number(6,4) = up to 100000 with four decimals but it is much better as number(6,2)
    ---------------------------------------------------------

    number(6) = maximum length of number you can enter is upto 999999.

    number with any limit defaults to maxium value which is upto 38 precisions.

    You should test this out by creating a test table with this datatype instead of waiting response from users on this site.
    Also, goto http://otn.oracle.com and download Oracle8i concepts pdf for more information on Oracle datatypes.

    Create table table1
    ( col1 number(6),
    col2 number,
    col3 number(6,4));

    and then insert maximum values using simple insert statement. I am sure you can do this.. Let me know if you need further explanation on this...

    Cheers!!!

    Mohammad Zahid
    Software Developer
    Database Management Applications.
    Vancouver, Canada
    E-mail: mzahid@shaw.ca

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jmodic
    Originally posted by julian
    from your answer above, somebody could get the impression that you can store 999999 into a number(6,4) field.
    Hardly. One should have a wild immagination to get the impression that 999999 can be stored into a number that was defined as "can stored values up to 100000 " (as defined by cekeke).
    :-) 99999 OK?

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by TheSlob
    :-) For how long time have you been using Oracle?


    I don't think you have to insult him by saying this. he's trying to help, if he's wrong just correct him. Besides, you've had some mistakes here yourself.
    Borrow some sense of humour ;-)

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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