Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: $1.88: I need to dump oracle tables...

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

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Tue, 31 Aug 1999 00:36:23 GMT
Message-ID: <bsFy3.2225$E46.1711@news.rdc1.pa.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US