oracle sqlplus 格式化输出的命令

 

SQL> select * from aa;

BB CC
---------- ----------
1 999999.99

SQL> col bb format /'99.9/';
SQL> select * from aa;

BB CC
----- ----------
1.0 999999.99

SQL> col bb head /'99.9/';
SQL> select * from aa;

99.9 CC
----- ----------
1.0 999999.99

SQL> col bb head /'学号/';
SQL> select * from aa;

学号 CC
----- ----------
1.0 999999.99

SQL> col bb format /'99/';
SQL> select * from aa;

学号 CC
---- ----------
1 999999.99

SQL> col bb head /'学|号/';
SQL> select * from aa;

学
号 CC
--- ----------
1 999999.99

SQL> select count(bb),sum(cc) from aa;

COUNT(BB) SUM(CC)
---------- ----------
8192 8191999918

SQL> col sum(cc) format /'9999999999.99/';
SQL> select count(bb),sum(cc) from aa;

COUNT(BB) SUM(CC)
---------- --------------
8192 8191999918.08

SQL> col sum(cc) format /'9999999999.99/' head /'总分/';
SQL> col count(bb) format /'999999/' head /'人数/';
SQL> select count(bb),sum(cc) from aa;

人数 总分
------- --------------
8192 8191999918.08

程序员特区

http://coderarea.net/html/shujukukaifa/Oracle/2009/0311/60358.html