SQL column name with comma

Question

im creating a csv file from sql and i must have column title name with comma like:

id,name,company
1,ART,Oracle

select ( id || ',' || name || ',' || company ) as **????????** from emplo

is there any way to display a sql column title with commas?

Answer 1

use " to contain your column name.

select ( id || ',' || name || ',' || company )  "id,name,company" 
from emplo