Home » SQL & PL/SQL » Client Tools » Export data into excel file (UNIX)
Export data into excel file [message #361163] Tue, 25 November 2008 04:24 Go to next message
fakru.y
Messages: 34
Registered: May 2007
Member
Can any onae tell me how to export data into excel file using Oracle procedures & cursors?
Re: Export data into excel file [message #361168 is a reply to message #361163] Tue, 25 November 2008 04:31 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you try to search before asking?
You can do it by creating a comma separated file (.csv)
Re: Export data into excel file [message #361170 is a reply to message #361168] Tue, 25 November 2008 04:50 Go to previous messageGo to next message
fakru.y
Messages: 34
Registered: May 2007
Member
I want to do this using cursors in a procedure
Re: Export data into excel file [message #361177 is a reply to message #361170] Tue, 25 November 2008 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Frank wrote on Tue, 25 November 2008 11:31
Did you try to search before asking?

Re: Export data into excel file [message #361232 is a reply to message #361170] Tue, 25 November 2008 08:07 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Write the data out to a file using UTL_FILE
Re: Export data into excel file [message #377386 is a reply to message #361163] Mon, 22 December 2008 12:23 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
On sqlplus it is some time possible.

Look for

set markup html on

Thanks
Trivendra
Re: Export data into excel file [message #377388 is a reply to message #377386] Mon, 22 December 2008 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does excel read HTML files?

Regards
Michel
Re: Export data into excel file [message #377416 is a reply to message #361163] Mon, 22 December 2008 23:05 Go to previous message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Sorry Michel, Misread the question.

But,We can simply spool the query data into excel file using this

set command.

Like

set ..
set ..
set markup html on
spool \test.xls
select level,level+2 from dual connect by level<=10;
spool off


Thanks
Trivendra

[Updated on: Mon, 22 December 2008 23:10]

Report message to a moderator

Previous Topic: Is there any tool to build Oracle queries?
Next Topic: Drop Procedure
Goto Forum:
  


Current Time: Wed Dec 07 22:13:57 CST 2016

Total time taken to generate the page: 0.05390 seconds