how to dump a query result into a spraed sheet?????

[kanthbethi]

Hi all

Is there any way we can dump the result of sql query(on oracle) into a spread sheet?????

for example::

select eno, ename, job, dept, mgr from emp;

and the query fetches say about 100000 records and the width of a paper is not enough as the result is more than twice of a A4 size paper. So i want spool the extract into a spreadsheet.

Any help would be greatly appreciated.

raj

[sysdba]

why not set ODBC data source and use MS excel to get
your data directly?

[kanthbethi]

Nice but I dont wanna use ODBC, then what???????

[PSoni]

hi.

Spool the result into a text file and open it into excel.


Soni

[adewri]

Do

spool out.csv
select empno||','|| ename||','|| job||','|| deptno||','|| mgr from emp;
spool off

This will create a comma seperated output and spool it in a .csv file which you can directly open in an excel sheet.

[vishal sood]

U can use Spool and for readable format, from SQL prompt, u can set ur enviroment by setting linesize->custome and type the Nunber, and set the Pagesize to custome and type the Number.

By this, u will be able to increase ur horizental & vertical lines.

The spool file which u have created can be opened in Excel.

[kanthbethi]

Thanks heaps AMAR, it really helped me a lot.

Regards