Oracle Database Discussions

I have a spooling problem. i would like to display header row only once. my select gives back 500 records, i need to display header row in pipe delimited file. the problem is that the spool file header is creating with only few columns. lets say table have 20 columns and spool file header is creating with only 10 column. I am getting values for all columns in spool files.

when I run select sql munually in toad I am seeing all column names are disply.

Do you have any idea how to solve to only show all column names in header at the beginning?

thanks in advance

i use the following sets



set pagesize 8000;
set heading on;
set verify off;
set trimspool on;
set feedback off;
set underline off;
set echo off;
set termout off;