Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> excel prepare using plsql program, excel prepare using plsql program
ravidb
post Apr 26 2012, 11:28 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 26-April 12
Member No.: 47,138



Hi,

in my plsql program(procedure) i have queries to fetch data from database. now i want to export those query results to an excel and store on my local machine drive path.

Here i don't want to use directory creation, please suggest plsql logic how can i achieve this.

Ravi
Go to the top of the page
 
+Quote Post
sishyadba
post Apr 26 2012, 01:21 PM
Post #2


Member
**

Group: Members
Posts: 21
Joined: 14-February 08
Member No.: 17,407



you can't write to disk from pl/sql unless there is a Oracle directory created mapping to the windows folder structure.

from sqlplus using the spool you can create a .csv file which can be opened using the excel.

Sri
Go to the top of the page
 
+Quote Post
burleson
post Apr 27 2012, 08:13 AM
Post #3


Advanced Member
***

Group: Members
Posts: 11,318
Joined: 26-January 04
Member No.: 13



Hi Ravi,

>> i have queries to fetch data from database.

I recommend Excel-DB for this:


http://www.dba-oracle.com/oracle_tips_excel_spreadsheet.htm

*****************************

>> please suggest plsql logic how can i achieve this.

Utl_file, but you stil have to tell it what directory to use!

http://www.remote-dba.net/t_advanced_utl_file_package.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th July 2014 - 02:59 PM