Option in sql script to include column headers when spooling file to .csv format

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement.

Thanks,

Akbar

2

are you doing set head off??
if not you will get column header in spooled file

3

Are you suggesting remove set head off line or change it to set head on?

thanks

4

if you used set pagesize to 0 delete it
or else use set head on option

5

page size entry removed and I am getting header.

thanks a lot.