how to print the output of a plsql block to excel sheet automatically

2635566

Hi Gurus,

I have one scenario,i have one table and i want to get all of the data in that table to an excel sheet using procedure automatically,Please guide me am new to Oracle.

ThnX in advance

Regards

Sree

BluShadow

Please see the FAQ:

EdStevens

Depends on your exact needs.  You can have the procedure create it as per previous posts, or you can have an existing Excel workbook read the database via an odbc connection.

============================================================================

BTW, it would be really helpful if you would go to your profile and give yourself a recognizable name.  It doesn't have to be your real name, just something that looks like a real name.  Who says my name is really Ed Stevens?  But at least when people see that on a message they have a recognizable identity.  Unlike the system generated name of 'ed0f625b-6857-4956-9b66-da280b7cf3a2', which is no better than posting as "Anonymous".

All you ed0f625b-6857-4956-9b66-da280b7cf3a2's look alike . . .

============================================================================