Re: Need MERGE without UPDATE clause

Connor McDonald wrote:
>> I have a question regarding the MERGE statment.
>> Can I do a merge with no update clause?
>[quoted text clipped - 22 lines]
>> VALUES ( S.TIME_ID ,S.STORE_ID ,S.REGION_ID,S.PARTS ,S.SALES_AMT ,S.
>> TAX_AMT ,S.DISCOUNT);
>
>10g, the clauses become optional

thanks, but we are not on 10g yet for this instance. I followed Mark's advice, and it worked like charm.

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200507/1