OraFAQ Forum: Client Tools » Export data into excel file

Home » Other » Client Tools » Export data into excel file (UNIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export data into excel file [message #361163]

Tue, 25 November 2008 04:24

fakru.y
Messages: 34
Registered: May 2007

Member

Can any onae tell me how to export data into excel file using Oracle procedures & cursors?

Report message to a moderator

Re: Export data into excel file [message #361168 is a reply to message #361163]

Tue, 25 November 2008 04:31

Frank
Messages: 7901
Registered: March 2000

Senior Member

Did you try to search before asking?
You can do it by creating a comma separated file (.csv)

Report message to a moderator

Re: Export data into excel file [message #361170 is a reply to message #361168]

Tue, 25 November 2008 04:50

fakru.y
Messages: 34
Registered: May 2007

Member

I want to do this using cursors in a procedure

Report message to a moderator

Re: Export data into excel file [message #361177 is a reply to message #361170]

Tue, 25 November 2008 05:17

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Frank wrote on Tue, 25 November 2008 11:31

Did you try to search before asking?

Report message to a moderator

Re: Export data into excel file [message #361232 is a reply to message #361170]

Tue, 25 November 2008 08:07

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Write the data out to a file using UTL_FILE

Report message to a moderator

Re: Export data into excel file [message #377386 is a reply to message #361163]

Mon, 22 December 2008 12:23

trivendra
Messages: 211
Registered: October 2007
Location: Phoenix

Senior Member

On sqlplus it is some time possible.

Look for

set markup html on

Thanks
Trivendra

Report message to a moderator

Re: Export data into excel file [message #377388 is a reply to message #377386]

Mon, 22 December 2008 12:35

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Does excel read HTML files?

Regards
Michel

Report message to a moderator

Re: Export data into excel file [message #377416 is a reply to message #361163]

Mon, 22 December 2008 23:05

trivendra
Messages: 211
Registered: October 2007
Location: Phoenix

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 13:03:56 CST 2024