From: "NormaJean S" Subject: Re: Need MERGE without UPDATE clause Newsgroups: comp.databases.oracle.server Date: Thu, 07 Jul 2005 21:54:09 GMT References: <50F02DE291C40@DBMonster.com> <42CD3ACC.6060@yahoo.com> Organization: http://www.DBMonster.com Message-ID: <50FB89AC2F830@DBMonster.com> X-Abuse-Report: http://www.DBMonster.com/Uwe/NB/Abuse.aspx NNTP-Posting-Host: 216.32.72.34 X-Trace: advenet.com 1120773249 216.32.72.34 (7 Jul 2005 17:54:09 -0400) Lines: 16 Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.tiscali.de!newsfeed.freenet.de!newsfeed.kamp.net!news.jgaa.com!advenet.com!not-for-mail Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246812 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