Re: retrieving data from tables into an ascii file

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 14 Jul 1999 21:35:25 -0400
Message-ID: <UMaj3.173$w3.276@news.ipass.net>

Here ya go (from SQL*Plus):

SPOOL myfile.txt
SELECT column1||CHR(nn)||column2||CHR(nn)...FROM tablewhatever WHERE......whatever;
SPOOL OFF The CHR function returns the character for whatever ascii code you give it, so give it the ascii code for a TAB. (I don't have the codes memorized yet, but I'm workin' on it......)

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

malikg_at_my-deja.com wrote in message <7mio4v$pkj$1_at_nnrp1.deja.com>...
>i need to extract data from tables for export
>into an ascii file with tabs converted into
>spaces and then ftp that file over to another
>site. how can I extract the data with tabs
>converted to spaces into an ascii export file.
>thanks
>Malik
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Jul 14 1999 - 20:35:25 CDT