I added a ; works now.

Ok I tried this in SQL PLUS and it works only thing is it wraps in multiple lines and not just one line.

Is there a way to have the data to be displayed in one line and not in multiple lines?
set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on
spool AdvisorClientGr oupFact.txt
select MONTH_DSI_ID || ',' || GRP_DSI_ID || ',' ||ADV_DSI_ID || ',' || GRP_STAT_DSI_ID...

I am trying to load some data into CSV files but I get this error message:

ORA-00922, missing or invalid option.

set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on
spool AdvisorClientGr oupFact.txt
select MONTH_DSI_ID || ',' || GRP_DSI_ID || ',' ||ADV_DSI_ID || ',' || GRP_STAT_DSI_ID || ',' || VALUE_TIER_DSI_ ID || ',' || PLATFM_DSI_ID || ',' || FP_STAT_DSI_ID || ',' || ORG_DSI_ID ||...