开发者

displaying results vertically in oracle

开发者 https://www.devze.com 2022-12-19 10:15 出处:网络
I\'m enamored with mysql\'s \\G feature which I find very usefulwhen SELECTing from tables with many colu开发者_JAVA技巧mns. Is there a similar feature in oracle which displays each column on its own

I'm enamored with mysql's \G feature which I find very useful when SELECTing from tables with many colu开发者_JAVA技巧mns. Is there a similar feature in oracle which displays each column on its own line? How do people normally deal with this issue?


I use Tom Kyte's print_table procedure

For example:

SQL> exec print_table('select * from emp where empno=7839')
EMPNO                         : 7839
ENAME                         : KING
JOB                           : PRESIDENT
MGR                           :
HIREDATE                      : 17-nov-1981 00:00:00
SAL                           : 100
COMM                          : 500
DEPTNO                        : 10
-----------------

PL/SQL procedure successfully completed.
0

精彩评论

暂无评论...
验证码 换一张
取 消