Expert: Suchitra Joshi - 4/14/2009

Question
How to convert oracle output text document into excel file.

If its possible please suggest me.

Thanks,
kamlesh.

Answer
Hi Kamlesh,

These are some ways to convert oracle output to excel file -

1) Using TOAD - select the rows from the table which are to be exported and save as excel or csv.
2) Using SQL*Plus - create a comma delimited file using the spool command and select statement as follows -

 spool emp
 select empno || ',' || ename || ',' || deptno from emp;
 spool off

 This will create emp.lst file. Open this using Excel.

Hope this helps.

Regards

Suchitra