Forum Stats

  • 3,854,173 Users
  • 2,264,332 Discussions


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

2635566 Member Posts: 7
edited May 6, 2014 7:50AM in SQL & PL/SQL

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





  • BluShadow
    BluShadow Member, Moderator Posts: 42,342 Red Diamond

    Please see the FAQ:

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown

    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 . . .


This discussion has been closed.