How can i switch off the heading on 3rd column out of 5 columns

[saketbansal]

I have a query with five columns. I have to dipalay third column without the heading as i have to concatenate the label with the field value so how can i supress this third column heading in SQL report.

i am using column,break and all to format the Report.

please suggest.

 

[Dagon]

What are you using to produce this report ? Is it SQL*PLUS ? If you want no heading in SQL*Plus, you could use the column command to give a blank heading:

col column_name heading ''

 

[SantaMufasa]

Saket,

If you are using SQL*Plus, then one method is to use a SQL*Plus COLUMN definition containing a NULL heading:

col x heading '' format a8
select last_name, first_name, 'Dept. '||dept_id x, salary
from s_emp;

LAST_NAME       FIRST_NAME                   SALARY
--------------- --------------- -------- ----------
Velasquez       Carmen          Dept. 50       2500
Ngao            LaDoris         Dept. 41       1450
Nagayama        Midori          Dept. 31       1400
Quick-To-See    Mark            Dept. 10       1450

Notice that I, too, concatenated the column heading withing the row output, and there is no displayed heading for that column amongst the heading-line entries.

Let us know if this resolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[SantaMufasa]

Sorry, Dagon, I must have been composing a solution while you were posting...I wish Tek-Tips could give you a pop-up that notifies you that someone has posted to the thread to which you are replying. Then it wouldn't look like the second poster is such a goof.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[saketbansal]

Thanks Mufasa

I alreday tried this thing but actually this line also creates problem beacuse we have 50 coiumns in our query which we have to dispaly in 4-5 lines . So this line also diplays in header and wraps in header when the columns wraps according to linesize.


So i want underline for all column headings except the one without heading.


Thanks

 

[SantaMufasa]

Saket,

To help us resolve your need, could you please post sample output that you would like to see for columns 2,3, and 4, complete with heading text, underlines, and sample data?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]