Column header

Hello all,

We are trying to run a script in Oracle DB from AIX.

We need to set the Column Header while executing the query to generate the Output.

For eg.

select city, name from emp;

It need to generate report in .csv format as

CITY NAME

atla tom
cincin jack

How I can write a shell to get the column heading as CITY, NAME in unix.

Thanks and Regards,
Milan

I think what you are asking for is something like this:

echo '"NAME","CITY","ZIP","PHONE" '

Then do your select command.