And why do you think this is a bad (complex) approach? Especially in your case, when you even don't need to update base table, just insert in case data does not exist.
On 9/29/05, Ranko Mosic <ranko.mosic@(protected)> wrote: > This is what we are doing now ( in a little bit more convoluted fashion, but > that's it ).
-- Best regards, Edgar Chupit callto://edgar.chupit -- http://www.freelists.org/webpage/oracle-l