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.
