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 Wed May 30 2001 - 07:55:20 CDT
