sql - how to put double quotes of the select output header in oracle? -

sql - how to put double quotes of the select output header in oracle? -

how set double quotes on each of header in select output in oracle ? because need export in csv file, , want this

e.g

"columnaheader1", "columnheader2", "columnheader3" "col1data1","col2data1","col3data1" "col2data2","col2data2","col3data2"

because in current query when like

e.g

case when blahblah not null '""' end "header" tablename

the header still not enclosed in double quotes..how in oracle ?

referenct schema object names , qualifiers

quoted identifiers can contain characters , punctuations marks spaces. however, neither quoted nor nonquoted identifiers can contain double quotation marks or null character (\0)

so have export header info instead.

you union headers dual table this:

select 'columnaheader1', 'columnheader2', 'columnheader3' dual union select ...

sql oracle