Re: Insert new record and update exist

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 15 Aug 2003 10:45:51 -0700
Message-ID: <6d8b7216.0308150945.5b323fe7@posting.google.com>

mhakimjavadi_at_hotmail.com (Mohammad) wrote in message news:<cc59b627.0308150635.56992bc2_at_posting.google.com>...
> Hi,
>
> I have problem to make query to check the Oracle table for update,if
> record is new inster that and if it is exist record just update that.
>
> The insert record works fine. How do I can check if it is exits just
> update that.
>
>
> Thank you for you help
>
> Mohammad

If you are running 9i, look at the merge statement.

Regards,

Steve Received on Fri Aug 15 2003 - 12:45:51 CDT