Ò»¸öoracleÎÊÌâ - Oracle / ¿ª·¢

±ÈÈç±íÀïµÄÒ»¸ö×Ö¶ÎÀàÐÍΪ£º number(16,2)

ÏÖÔÚËûÓÐÒ»¸öÖµÊÇ15.02 µ«ÎÒÏÖÔÚÐèÒªËüÔÚÏÔʾ³É15.0200

ÎÒÏëÎÊÏ¡£²»ÒªÓÃselect tochar(,99999.9999) from

¶øÊÇÖ±½Óslect from tab 

Òâ˼¾ÍÊÇ˵15.02 ´æ´¢ÔÚÊý¾Ý¿âÀï¾ÍÊÇ15.0200

ÓÐûÓпÉÄÜ×öµ½£¿

---

¶¨Òå³É×Ö·û´®ÀàÐÍÈçvarchar2»òchar
Êý×ÖÐÍÎÞ·¨×öµ½£¬Ö»ÊÇÒ»¸öÏÔʾÎÊÌâ

---

create table t_a (ixd number(10,4));
insert into t_a values(15.7700);
select * from t_a;

IXD
----------
15.7700

---

³ý·ÇÄã±¾Éí×Ö¶ÎÓÐСÊýÏÞÖÆ,·ñÔòºóÃæµÄ0±»ºöÂÔ,

---

ÒýÓÃ

SQL> create table test (num number(16,2));

±íÒÑ´´½¨¡£

SQL> insert into test values (15.02);

ÒÑ´´½¨ 1 ÐС£

SQL> commit;

Ìá½»Íê³É¡£

SQL> select * from test;

NUM
----------
15.02

SQL> col ¡­¡­

ͬÒâ

---

ÒýÓÃ

create table t_a (ixd number(10,4));
insert into t_a values(15.7700);
select * from t_a;

IXD
----------
15.7700

ÉÏÃæµÄÄǸöµã´íÁË£¬ ͬÒâÕâ¸ö

---

ÎÒ´ò´íÁË ÆäʵÊDZÈÈç±íÀïµÄÒ»¸ö×Ö¶ÎÀàÐÍΪ£º number(16,4)
ÒªÏÔʾ³É12.0200

---

SQL code:

Create Table t (idd Number(10,4));

Insert Into t Values(10.02);