MS-SQL float equivalent in Oracle [message #21148] |
Tue, 16 July 2002 03:30 |
Cheni
Messages: 2 Registered: July 2002
|
Junior Member |
|
|
Hi, I need to convert from MS-Sql7 to Oracle817 , the data type float,, Can I use Oracle float straightaway? How can i ensure that min and max values will properly get converted from MS-Sql7 to Oracle 817? Thanx n Regards cheni
|
|
|
Re: MS-SQL float equivalent in Oracle [message #21151 is a reply to message #21148] |
Tue, 16 July 2002 05:35 |
Try
Messages: 8 Registered: July 2002
|
Junior Member |
|
|
The NUMBER datatype stores fixed and floating-point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle, up to 38 digits of precision.
column_name NUMBER (precision, scale)
data type NUMBER is for all number types in oracle
Input Data Specified As Stored As
--------------------------------------------------
7,456,123.89 NUMBER 7456123.89
7,456,123.89 NUMBER(*,1) 7456123.9
7,456,123.89 NUMBER(9) 7456124
7,456,123.89 NUMBER(9,2) 7456123.89
7,456,123.89 NUMBER(9,1) 7456123.9
7,456,123.89 NUMBER(6) (not accepted,exceeds precision
7,456,123.89 NUMBER(7,-2) 7456100
min,max are similar once u take care of datatype
|
|
|