Re: what do I know Oracle 9i MERGE statement is done via insert or update

Peter vu wrote:

> After the completion of oracle 9i MERGE statement, I would like to do
> some processing depend on whethere the data is insert or updated.
>
> What is the best way to do it?

If you are going to have an IF statement ... have an IF statement.

This is not an appropriate use of MERGE.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)