Show/Hide column name

[HWG]

Hi All,

In sqlplus, what set option is used to show/hide the column name from
the sql return?

e.g.

select * from dual;
X

v.s.

select * from dual;

D
-
X

If I would like to see the column name DUMMY is hidden, how can I do
that?

[Hans Forbrich]

Re: Show/Hide column name

HWG wrote:

Hi All,
>
In sqlplus, what set option is used to show/hide the column name from
the sql return?
>
e.g.
>
select * from dual;
X
>
v.s.
>
select * from dual;
>
D
-
X
>
If I would like to see the column name DUMMY is hidden, how can I do
that?

http://docs.oracle.com

>Oracle9i Database Release 2
>View Library
>list of books
>SQL*Plus User's Guide and Reference
>Chapter 7

And when you're comfortable with that, 'SQL*Plus Quick Reference' is a
reasonable reminder.

[Pratap]

Re: Show/Hide column name

set head off

Pratap