oracle sqlplus 格式化輸出的命令
來源：互聯網
上載者：User
oracle
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
