Home » SQL & PL/SQL » SQL & PL/SQL » Lost my column headings
Lost my column headings [message #225002] Fri, 16 March 2007 08:52 Go to next message
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
Re: Lost my column headings [message #225005 is a reply to message #225002] Fri, 16 March 2007 09:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SET PAGESIZE 0 will also cause the column headings to disappear.
You can see your current Pagesize with SHOW PAGESIZE
Re: Lost my column headings [message #225018 is a reply to message #225005] Fri, 16 March 2007 10:14 Go to previous message
cumin
Messages: 82
Registered: August 2005
Member
Thank you.
Previous Topic: ZIPCODE ISSUES with query
Next Topic: ORA-01033: ORACLE intialization or shutdown in progress
Goto Forum:
  


Current Time: Sun Dec 04 06:27:03 CST 2016

Total time taken to generate the page: 0.07516 seconds