user10070712 wrote:below is valid syntax & won't throw error
Hello, thank you for the providing the solution. However, upon running the sql I received this error "missing or invalid operation'.
Might want to check the syntax if it's correct?
set colsep ,
set heading off
set feedback off
select row_id, created, if_row_batch_num, if_row_stat, name from siebel.eim note order by desc;
I also set this from above syntax <set colsep ','> still, did not work.
You might want to remove the SPOOL command and add where rownum < 5 to your query until it looks the way you want.
SQL> set serveroutput on SQL> set colsep ',' SQL> set heading off SQL> set feedback off SQL> select empno, ename from emp; 7369,DALLAS 7499,CHICAGO 7521,CHICAGO 7566,DALLAS 7654,CHICAGO 7698,CHICAGO 7782,NEW YORK 7788,DALLAS 7839,NEW YORK 7844,CHICAGO 7876,DALLAS 7900,CHICAGO 7902,DALLAS 7934,NEW YORK SQL>