Home » SQL & PL/SQL » SQL & PL/SQL » write pl/sql result in xl sheet
icon7.gif  write pl/sql result in xl sheet [message #257724] Thu, 09 August 2007 01:36 Go to next message
anuchowdary.k
Messages: 6
Registered: August 2007
Location: bangalore
Junior Member

Hi ,
This is anu ,can any one explain how to tranfer the output of one query(pl/sql) to an exl sheet.
Thanku.
Re: write pl/sql result in xl sheet [message #257749 is a reply to message #257724] Thu, 09 August 2007 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, search for Excel here, on AskTom, on Google.

Regards
Michel
Re: write pl/sql result in xl sheet [message #258058 is a reply to message #257724] Fri, 10 August 2007 00:34 Go to previous messageGo to next message
anuchowdary.k
Messages: 6
Registered: August 2007
Location: bangalore
Junior Member

hi ,
i got some information regarding this. A new additional s/w sql loader will helps u to send output of sql query to exl sheet. can anyone explain indetail.
Thanku
Re: write pl/sql result in xl sheet [message #258063 is a reply to message #258058] Fri, 10 August 2007 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between SQL*Loader and "send output of sql query to exl sheet"?
Precise your need. What do you want to achieve?

Regards
Michel

Re: write pl/sql result in xl sheet [message #258091 is a reply to message #258063] Fri, 10 August 2007 03:04 Go to previous messageGo to next message
anuchowdary.k
Messages: 6
Registered: August 2007
Location: bangalore
Junior Member

Actually one of my frnd told that by using sql loader we can transfer our sql query output data into exl sheet. thats y i asked. is it possible in sql.
Re: write pl/sql result in xl sheet [message #258103 is a reply to message #258091] Fri, 10 August 2007 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Loader is for... loading.
It doesn't output any data.

And if you searched as I said you find how to outout into Excel with PL/SQL.

Regards
Michel
Re: write pl/sql result in xl sheet [message #262169 is a reply to message #258091] Fri, 24 August 2007 15:01 Go to previous message
appsamar
Messages: 8
Registered: April 2007
Junior Member
Hello Anu,

You can not use Sql * laoder for outputting sql code in to Excel sheet..

Using UTL_FILE you can able to output the data from sql query in to excel sheet

Sql * loader is used to load data from flat file (text,csv) in to data base tables,

UTL_FILE is used to output data from database tables in to flat file

Hope this information is helpful for you..

Thanks
Amar
Previous Topic: Paging Row selection retention & ORA-14450 (merged)
Next Topic: Join or subquery, which is faster
Goto Forum:
  


Current Time: Thu Dec 08 02:13:47 CST 2016

Total time taken to generate the page: 0.06638 seconds