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]

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]

set head off

Pratap