Can't seem to print the column headers 1

[rogers42]

Hi Folks,

I can't seem to print the column headings. E.g. The following simply prints "X" but no heading

select * from dual;

show heading command displays ON.

Is there any other setting that might be supressing the column header printing ?

Thanks in advance.

rogers42

 

[SantaMufasa]

Is there any other setting that might be supressing the column header printing ?

Yes...if at any time in your session this instruction has executed:

SET PAGESIZE 0

Set pagesize to some positive value and re-run your code.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[rogers42]

Hi Mufasa,

Right you are, yet again. pagesize = 0 is the first thing I do after logging in the db.

Thanks once again for answering all my questions through out the year.

Happy holidays to everybody.

rogers42