select * 但却不想显示所有列的示例脚本:
if you using sqlplus
you can use the noprint tag
SQL> col noprint
代码:--------------------------------------------------
1 select * from tab
2* where rownum < 2
rollingpig@test> /
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
A TABLE
1 row selected.
rollingpig@test> col CLUSTERID noprint
rollingpig@test> l
1 select * from tab
2* where rownum < 2
rollingpig@test> /
TNAME TABTYPE
------------------------------ -------
A TABLE
1 row selected.
rollingpig@test>
...
