Re: Newbee - add column headings to a flat file using SQL+ ?

On Fri, 07 Aug 1998 15:15:13 GMT, ebab_at_my-dejanews.com wrote:

>Is there a way to add column headings and a title to a flat file thru' SQL+ ?
>
>Right now I am doing a
>
>SET PAGESIZE 0
>SET NEWPAGE 0
If you just want ONE heading, you might try issuing two select statements, one for the title and one for the heading. For example:

column date format a10
column name format a30

select 'Date' date,

       'Name' name
   from dual;

select date,

       name
  from your_table; Received on Sun Aug 09 1998 - 16:55:26 CEST