| Value | Datatype | Stored Value |
| 123.2564 | NUMBER | 123.2564 |
| 1234.9876 | NUMBER(6,2) | 1234.99 |
| 12345.12345 | NUMBER(6,2) | Error |
| 1234.9876 | NUMBER(6) | 1235 |
| 12345.345 | NUMBER(5,-2) | 12300 |
| 1234567 | NUMBER(5,-2) | 1234600 |
| 12345678 | NUMBER(5,-2) | Error |
| 123456789 | NUMBER(5,-4) | 123460000 |
| 1234567890 | NUMBER(5,-4) | Error |
| 12345.58 | NUMBER(*, 1) | 12345.6 |
| 0.1 | NUMBER(4,5) | Error |
| 0.01234567 | NUMBER(4,5) | 0.01235 |
| 0.09999 | NUMBER(4,5) | 0.09999 |
| 0.099996 | NUMBER(4,5) | Error |
新聞熱點
疑難解答
圖片精選