Home » SQL & PL/SQL » SQL & PL/SQL » Exporting Oracle data to Excel file
Exporting Oracle data to Excel file [message #341569] Tue, 19 August 2008 06:29 Go to next message
singhsn
Messages: 2
Registered: August 2008
Junior Member
Hi,

How can I export the data from an Oracle table into an excel file?

Thanks in advance.

Re: Exporting Oracle data to Excel file [message #341572 is a reply to message #341569] Tue, 19 August 2008 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just with a search in the forum.

Regards
Michel
Re: Exporting Oracle data to Excel file [message #341589 is a reply to message #341569] Tue, 19 August 2008 07:51 Go to previous messageGo to next message
rajeshwaranbtech
Messages: 4
Registered: August 2008
Location: Chennai
Junior Member
Just use this command to get the output in excel.

SQL> spool c:\test\emp_result.xls;
SQL> select * from emp;

< Your result sets may go Here...>

SQL> spool off;
Re: Exporting Oracle data to Excel file [message #341593 is a reply to message #341589] Tue, 19 August 2008 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have at least to set column separator.

Regards
Michel
Re: Exporting Oracle data to Excel file [message #341596 is a reply to message #341589] Tue, 19 August 2008 08:09 Go to previous messageGo to next message
singhsn
Messages: 2
Registered: August 2008
Junior Member
Many thanks Raj.

The data is written to an excel sheet but the data is not coming in a proper format. Is there any other way we can have the data in a proper tabular format(1 table in 1 file) in the excel sheet.(Without using any other software.)
Re: Exporting Oracle data to Excel file [message #341607 is a reply to message #341596] Tue, 19 August 2008 09:02 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 19 August 2008 15:04
You have at least to set column separator.

Regards
Michel


Previous Topic: Need to know
Next Topic: SQL Function query
Goto Forum:
  


Current Time: Sun Dec 04 06:46:50 CST 2016

Total time taken to generate the page: 0.05560 seconds