OraFAQ Forum: SQL & PL/SQL » Lost my column headings

Home » SQL & PL/SQL » SQL & PL/SQL » Lost my column headings

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Lost my column headings [message #225002]

Fri, 16 March 2007 08:52

cumin
Messages: 82
Registered: August 2005

Member

For some reason that I don't understand, I no longer get column headings. I did not change login.sql, and this change persists over startups of the db (I am using Oracle Personal Edition). The documentation tells me this can be due to the HEADING system variable, but setting it to ON does not help.

This shows what I mean:

create table test(
   name varchar2(10),
   id number);

insert into test values ('first', 1);

insert into test values ('second', 2222222);

set hea on

select * from test;
first               1
second        2222222

Report message to a moderator