Re: dropping a csv file from an oracle table for reporting purposes

From: Neil <npluckne_at_ford.com>
Date: 3 May 2001 13:49:03 GMT
Message-ID: <Xns909696CB0A2DF24361267ford@19.5.30.190>

"Nicholas Mudie" <nmudie_at_chello.com> wrote in <nCcI6.36074$Kt6.7357295_at_amsnews03.chello.com>:

>Hi everyone,
>
>I'm trying to drop a csv file from an oracle table to do some reporting
>via perl.
>
>How would I drop a csv file using Oracle or pl sql??
>
>Thanks,
>Nicholas Mudie
>Apps Engineer
>CHELLO
In SQLPLus try setting "spool=on" then running a select statement seperated by the "||,||".eg:
spool c:\TMODELEINITFPP20000423.txt
select
VERSION_NUMBER||','||RECORD_TYPE||','||EMPLOYEE_ID_PREFIX||','||EMPLOYEE_ID ||','||FIRST_NAME||','||LAST_NAME
from SYS.FPP_DATA_FOR_FECP;
spool off

hth,

Neil. Received on Thu May 03 2001 - 08:49:03 CDT