Re: Insert/update with one command

"Anton Dischner" <nomail_at_nospam.org> wrote in message news:301120041456237057%nomail_at_nospam.org...
> Hi,
>
> i believe with some release of Oracle there was intruduced a command
> which combines insert/update of data into a table.
>
> What we do is:
>
> insert into ...
> if data exists -> failure -> use update command.
>
> what we are looking for is
> insert/update table ...
> if unique key -> update
> else insert
>
> Any ideas?
>
> Toni

its called merge - its in 9i Received on Tue Nov 30 2004 - 12:33:46 CST