Re: import data from text file; update existing rows; no delete

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 17 Dec 2003 11:56:41 +0100
Message-ID: <3fe0367e$0$17120$626a54ce@news.free.fr>

"kaeli" <tiny_one_at_NOSPAM.comcast.net> a écrit dans le message de

news:MPG.1a48c606eb8ecad9989a05_at_nntp.lucent.com...

> In article <3fde13a1$0$28679$626a54ce_at_news.free.fr>, "Michel Cadot"
> <micadot{at}altern{dot}org> enlightened us with...
> > >
> >
> > If you have a 9i version, have a look at external table and merge statement.
> >
>
> We have 8.1.7.3.
>
> Any other ideas?
>
> Thanks!
> --
> --
> ~kaeli~
> Once you've seen one shopping center, you've seen a mall.
> http://www.ipwebdesign.net/wildAtHeart
> http://www.ipwebdesign.net/kaelisSpace
>

See Tom Kyte site (http://asktom.oracle.com). For example the thread "Best method to insert/update a table" at url: http://asktom.oracle.com/pls/ask/f?p=4950:8:1555728027419965316::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:9979278894243,

Hope this helps
Michel Cadot Received on Wed Dec 17 2003 - 04:56:41 CST