Show/Hide column name

#1

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?

#2

HWG wrote:

Quote:

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

Quote:

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.

#3

set head off

Pratap

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Show/Hide column name

comp.databases.oracle comp.databases.oracle

Show/Hide column name - 08-24-2004 , 05:18 PM

Re: Show/Hide column name - 08-24-2004 , 05:44 PM

Re: Show/Hide column name - 08-24-2004 , 11:23 PM