Re: "insert or update" in one step?

actually, UPSERT is not really a Teradata statement, but it is a descriptive name for the functionality available as part of the Teradata MLOAD utility. the control card file has to contain two separate SQL statements: an insert statement and an update statement, and then a single step can refer to an input file, and both of the statements. sweet!

it would be so nice to have this same functionality in the Oracle SQL*Loader utility. for a datamart/warehouse using Oracle 7.3, we prepared a file, ran sqlldr, got the discard file (duplicate key values), and used that as an input file to a Pro*C program to perform updates.

i wonder if 9i is going to include this functionality in the SQL*Loader. now that would be Sweet...!

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:991313547.19776.0.nnrp-12.9e984b29_at_news.demon.co.uk...
>
> Not necessarily a joke, UPSERT has been a valid
> command in one of the major databases (Teradata
> I think) for several years, and the question: 'I want to
> insert a row, or update it if it exists, what's the
> efficient method ?' is a prime candidate for any
> Oracle FAQ. (There was yet another thread started
> on it in the last few days).
>
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
>
> Patrick Sinke wrote in message <991311196.576145_at_sleeper.capgemini.nl>...
> >> In Orace9i you will have the command 'UPSERT' at your disposal.
> >>
> >
> >this must be a joke!
> >Maybe there will be a combined update/delete statement? Like uplete or
> >delate? ;)
> >
> >Regards,
> >Patrick.
> >
> >
> >
>
>
>
Received on Sat Jun 02 2001 - 02:54:29 CDT