about to_char(number): http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/functions132.htm#79332 about Number Format Elements: http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/sql_elements4.htm#34597
SQL> create table tn(aaa number);表已创建。SQL> insert into tn values(12.345);已创建 1 行。SQL> select * from tn; AAA ---------- 12.345 SQL> col aaa format 99999.9 SQL> select * from tn; AAA -------- 12.3SQL> col aaa format 99999.99999 SQL> select * from tn; AAA ------------ 12.34500SQL>
http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/functions132.htm#79332
about Number Format Elements:
http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/sql_elements4.htm#34597
----------
12.345
SQL> col aaa format 99999.9
SQL> select * from tn; AAA
--------
12.3SQL> col aaa format 99999.99999
SQL> select * from tn; AAA
------------
12.34500SQL>