Insert/update with one command

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 Received on Tue Nov 30 2004 - 07:56:23 CST