select*但却不想显示所有列的示例脚本

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>

...