excel prepare using plsql program, excel prepare using plsql program Options

[ravidb]

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

[sishyadba]

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

[burleson]

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