Home » SQL & PL/SQL » SQL & PL/SQL » floating value
floating value [message #197632] Thu, 12 October 2006 02:07 Go to next message
sjaiswal
Messages: 31
Registered: September 2006
Location: Mumbai
Member
Hi,
I have a small question.
I have to put the datatype as a column as :
DMDVAR NOT NULL FLOAT(126)

I wanted to know what exactly 126 means here.
The below detail I got from google says :-
Maximum precision of 126 binary digits, which is roughly equivalent to 38 decimal digits

Does this mean that it will support a format of
'00000000000000000000000000000000000000' digits.
I mean can there be a 38 digit long value? If not how large a value can it support.
Please clarify.


Thanks,
Sonali
Re: floating value [message #197640 is a reply to message #197632] Thu, 12 October 2006 02:26 Go to previous message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi

yes it means you can put 38 digits maximum

regards

Muhammad Shahid Mughal
Previous Topic: How to use Distinct clause to create the XML from SQLXML
Next Topic: Issue with NOT Exists when No Data
Goto Forum:
  


Current Time: Tue Dec 06 04:50:20 CST 2016

Total time taken to generate the page: 0.10307 seconds