--运行sqlplus

--查看v$session 2列数据

SQL> col saddr print

---查询显示saddr列

SQL> select saddr,state from v$session where rownum<=3;

SADDR STATE
---------------- --------------------------------------
000007FF7E4CF570 WAITING
000007FF7E4CC700 WAITING
000007FF7E4C9890 WAITING

--与上相反,查询不显示列saddr

SQL> col saddr noprint
SQL> /

STATE
--------------------------------------
WAITING
WAITING
WAITING

小结:1,适用于表列很多,用此可一个sql多次运行,仅修改不同的列是否显示即可.甚为方便

ITPub博客

sqlplus选项之column print_noprint