Number datatype or LONG?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Number datatype or LONG?

  1. #1
    Join Date
    Sep 2002
    Posts
    16
    Let me phrase my question again:

    All data will have two digits to the right of the decimal point (i.e., 25.xx). The numbers to the left of the decimal point will vary (i.e., 1234567890.xx). Which data type is most apporpriate?

    number or long?

    I know to the right is the number datatype.

    Do any one know, what will be the answer???




  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Number is a number datatype. Long is a character datatype, which can include numbers, but won't be a number, so why would you want to store a number in a non-number datatype?

  3. #3
    Join Date
    Sep 2002
    Posts
    16
    Argue is that, length is unknown in either side. I know you can only go for 128 characters for the digit and 38 characters for decimal. Right!!!

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    what is teh use of using the long columns for numeric columns u cannot use mathematical function on very large values .
    if u say
    select to_number ( '111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 1.1111111111111111111111111111111111111111111111111' ) from dual ;

    it throws an error numeric overflow .
    ofcourse it stores values in that .
    siva prakash
    DBA

  5. #5
    Join Date
    Sep 2002
    Posts
    16
    Again, Thanx for your help GUYS!!!

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