Re: ASCII Data Export

Hi,

Another way is to use oraperl.
You can also get the data out of the long column into a flat file.

like this:

  $lda = &ora_login($base, $user, '') || die $ora_errstr;   $csr = &ora_open($lda, "select * from $table") || die $ora_errstr;   while (@data = &ora_fetch($csr))
  {

      print "\"" . join("\", \"", @data) . "\"\n";   }
  warn "$ora_errstr" if $ora_errno;

bmuller_at_netmail.mnet.uswest.com wrote:
> Hi,
>
> Thanks for the response. I forgot to mention one important detail. One
> of the datatypes that I'm dealing with is "long". I don't believe I can
> select it in it's entirety through sqlplus. Or can I? Is there someway
> to get the data out of the long column into a flat file in text format?
>
> Thanks again!
>

--
dat_at_open.rd.nttdata.co.jp