Re: $1.88: I need to dump oracle tables...

select '"'||charfield1||'",'||'"'||charfield2||'", '||datefield||','||numfield
from YOUR_TABLE

On Sat, 21 Aug 1999 22:06:01 GMT, anandmali_at_my-deja.com wrote:

>I saw this question on respondnet.com. They're
>paying $1.88 for the answer. Thought someone
>here might know it.
>
>I need to dump oracle tables to proper comma
>delimited format files with strings in quotes,
>i.e. the same format you can use in sqlldr &
>most wordprocessors. Any clues much appreciated.
>
>http://www.respondnet.com/
>--------------------------------
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email