float datatype in Oracle database 【Blog 搬家】
float datatype in Oracle database
2005 年 08 月 25日, 星期四
作了一個測試,就像我們以前一直提醒的一樣。在使用非 number datatype 的 數字型別一定要注意。
create table t_float (f float(2),n number(2))
SQL> insert into t_float values (7,7);
1 row created.
SQL> insert into t_float values (11,11);
1 row created.
SQL> insert into t_float values (99,99)
1 row created.
1 row created.
SQL> select * from t_float;
F N
---------- ----------
7 7
10 11
100 99
---------- ----------
7 7
10 11
100 99
Why:
a FLOAT column with a binary precision of 2 bits, is implemented as a NUMBER column with 1 decimal digit of precision and no fixed scale. Thus the number 7, which requires 3 binary bits, will nevertheless be stored exactly, whereas the number 11, which has two decimal digits, will be rounded to 10 because only one decimal digit of precision is allowed.
It is legitimate for a database implementation to use higher precision than requested in this way. Therefore, database applications should always round data values explicitly when required, and should not rely on the precision of the datatype to round data implicitly.
暫時還有理解上面的含義 :(
myhuaer 發表於:2005.08.25 10:39 ::分類: ( Oracle Infomation ) ::閱讀:(470次)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-661931/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- float datatype in Oracle databaseOracleDatabase
- Oracle Database Link Problems【Blog 搬家】OracleDatabase
- oracle Database Event trace 設定【Blog 搬家】OracleDatabase
- Oracle backgroud Process【Blog 搬家】Oracle
- Database Triggers and event attributes--Database System Events【Blog 搬家】Database
- Database Link 建立注意的兩點【Blog 搬家】Database
- oracle Distinct|Unique 異同【Blog 搬家】Oracle
- Oracle DDL 執行過程【Blog 搬家】Oracle
- Database Triggers and event attributes--Introduction[Blog 搬家]Database
- Database Triggers and event attributes--Event Attributes【Blog 搬家】Database
- Database Triggers and event attributes--DDL/Client Events【Blog 搬家】Databaseclient
- Oracle event 10231 【Blog 搬家】Oracle
- Oracle Date Function 講解和事例【Blog 搬家】OracleFunction
- oracle ora-00997 problems【Blog 搬家】Oracle
- Oracle Optimizer -RBO (理解Rule-based 優化器)【Blog 搬家】Oracle優化
- HP -Data Protector Restore file system【Blog 搬家】REST
- V$SESSION_LONGOPS bug 【Blog 搬家】SessionGo
- 限制End User Session數量 【Blog 搬家】Session
- Trim() 函式的介紹【Blog 搬家】函式
- ora -03232 問題解決【Blog 搬家】
- RMAN 只備份當前資料?【Blog 搬家】
- Oracle10g V$OSSTAT 關於PHYSICAL_MEMORY_BYTES 的 Bug【Blog 搬家】Oracle
- oracle 9i database 在win2k server上搬家(轉摘)OracleDatabaseServer
- exp/imp expdp/impdp Tables 萬用字元 % 的使用【Blog 搬家】字元
- 資料庫加密Product_user_profile(PUP) TABLE FOR security 【Blog 搬家】資料庫加密
- MM-DD-RRRR / MM-DD-YYYY 的區別【Blog 搬家】
- oracle‘blogOracle
- Oracle實驗(04):floatOracle
- WPF DataTemplate DataType
- oracle-base blogOracle
- xsb Oracle BlogOracle
- partitioned by timestamp datatype
- oralce datatype-long
- Good site on Oracle tech blogGoOracle
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- Oracle clone databaseOracleDatabase
- ORACLE database vaultOracleDatabase