Home » SQL & PL/SQL » SQL & PL/SQL » Export Table Data into Excel sheet (Oracle ,10.2.0.1.0, Windows XP Professional)
Export Table Data into Excel sheet [message #377599] Tue, 23 December 2008 16:12 Go to next message
kumarbo7
Messages: 19
Registered: March 2008
Location: New Jersey
Junior Member
Hi,

I am using Oracle 10.2.0.1.0 ,Operating system Windows XP Professional.

I am looking is there any PL/SQL procedure to export Table data into Excel sheet.

Please let me know.

Thanks in advance
Kumar
Re: Export Table Data into Excel sheet [message #377602 is a reply to message #377599] Tue, 23 December 2008 16:25 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:728625409049
Re: Export Table Data into Excel sheet [message #377606 is a reply to message #377599] Tue, 23 December 2008 17:39 Go to previous messageGo to next message
kumarbo7
Messages: 19
Registered: March 2008
Location: New Jersey
Junior Member
Thanks alot Barbara.

I will modify the code as per my requirement

-Kumar
Re: Export Table Data into Excel sheet [message #377662 is a reply to message #377599] Wed, 24 December 2008 02:14 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It's a bit over the top I suspect, but if you set up Oracle HS (theres's a very good page in the FAQs here about how to do it) then you can write directly into a spreadsheet using CREATE TABLE, INSERT and UPDATE commands.

[correct Heterogeneous Services abbreviation]

[Updated on: Wed, 24 December 2008 02:20]

Report message to a moderator

Previous Topic: ORA-12805: parallel query server died unexpectedly
Next Topic: run in allowed time-zone
Goto Forum:
  


Current Time: Sun Dec 04 08:42:33 CST 2016

Total time taken to generate the page: 0.04273 seconds