oracle sqlplus 格式化输出的命令

发布: 2007-7-02 11:08 | 作者: admin | 来源: | 查看: 145次 | 进入软件测试论坛讨论

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