Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: $1.88: I need to dump oracle tables...
I didn't look it up, but there is a dbms_(I think utility) that does that
exact thing.
--
Bob Fazio
Remove no.spam from my email to reply
NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
news:37cab029.10021774_at_news.earthlink.net...
> 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
>
Received on Mon Aug 30 1999 - 19:36:23 CDT