Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor output to CSV

Re: Cursor output to CSV

From: Helge <hmoulding_at_gmail.com>
Date: 10 Jun 2006 10:51:52 -0700
Message-ID: <1149961912.934558.270120@f6g2000cwb.googlegroups.com>

Mladen Gogala wrote:
> On Fri, 09 Jun 2006 17:18:35 -0700, Mark D Powell wrote:
>
> > Well if you use SQLPlus as the front end you could declare a cursor
> > variable. Then you can dump the cursor contents with an SQLPlus print
> > command: print cursor_variable
>
> I must say that I'd use Perl to do that. SQL*Plus is not a reporting or
> extraction tool.

More to the point, in my case using SQLPlus isn't really an option. Don't know if Perl is an option. Can Perl be called from PLSQL and passed a ref cursor to create a csv file? Received on Sat Jun 10 2006 - 12:51:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US