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 
|