Oracle中怎么批量调整显示结果的列宽，不要column ** format a12;这样的答复~

Question

                                 SONGID SONGNAME                                                                                                         ALBUMID                         STYLECATAGORYID                      LANGUAGECATAGORYID                                SINGERID SHORTNAME                                                                        CHARCOUNT ADDDATE                                   PLAYCOUNT SONGPATH
--------------------------------------- -------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- -------------------------------------------------- --------------------------------------- ----------- --------------------------------------- --------------------------------------------------------------------------------
                                      1 那女孩对我说                                                                                                           3                                      12                                       1                                       3 nnhdws                                                                                   6 1999-6-9                                          0 F:\My Music\曲子\moon.wma
                                      2 微光                                                                                                                   3                                      12                                       1                                       3 wg                                                                                       2 2011-6-14 8                                       0 F:\My Music\曲子\moon.wma
                                      3 无与伦比的美丽                                                                                                         4                                       4                                       1                                       4 wylbdml                                                                                  7 2011-6-14 8                                       0 F:\My Music\my_favorite\无与伦比的美丽.mp3
                                      4 寂寞的季节                                                                                                             5                                      12                                       1                                       5 jmdjj                                                                                    5 2011-6-14 8                                       0 F:\My Music\my_favorite\寂寞的季节.mp3
                                      5 那女孩对我说2                                                                                                          3                                      12                                                                               3 nnhdws                                                                                   6 2011-6-14 8                                       0 F:\My Music\my_favorite\男人女人.mp3
 
这个让我感到很烦躁，这到底怎么来调整啊，难不成每列都用“column *** format a15;”这样来调？？
这一个表也就算了，其他我还有6~7张表呢，这样多费神儿啊
高手来帮忙看一下啊，千恩万谢啊！！！

Answer 1

--查询出的结果集作为SQL*PLUS命令执行
SELECT 'COL ' || t.COLUMN_NAME || ' for a15;'
  FROM user_tab_columns t
 WHERE t.TABLE_NAME IN ('大写表名1', '大写表名2');

Answer 2

使用lpad或者rpad进行格式化
例如：select lpad('aa',8-length('aa',' ') ,lpad('bbbb',8-length('bbbb',' ') 
     from    dual    --右对齐
      select rpad('aa',8-length('aa',' ') ,rpad('bbbb',8-length('bbbb',' ') 
     from    dual    --左对齐

Answer 3

column SONGID format 99
column SONGNAME format a15
column ALBUMID format 99
column STYLECATAGORYID format 99
column LANGUAGECATAGORYID format 99
column SINGERID format 99
column SHORTNAME format a10
column CHARCOUNT format 99
column PLAYCOUNT format a10
column SONGPATH format a30