Printable View
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???
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?
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!!!
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 .
Again, Thanx for your help GUYS!!!