Ian A. Newby wrote:

>
> Anyway, back to the question, I only like replace, the others are a
> bit obscure for me. Do any other databases support? A quick search on
> google suggests that oracle supports MERGE statements which seem to
> do a similar thing.
>

MERGE is a statement in the SQL standard with different syntax. It's
not a candidate.

Regards,


Ann