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>

 

...