Home » SQL & PL/SQL » SQL & PL/SQL » MERGE
MERGE [message #190596] Thu, 31 August 2006 06:21 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi

Is there any command in oracle 8/8i which do same function of MERGE in oracle 9i?

regards,

Sam chacko

Report message to a moderator

Re: MERGE [message #190601 is a reply to message #190596] Thu, 31 August 2006 06:36 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Nope. Use INSERT and UPDATE.

If you have a long-running complex SQL to determine a result-set that you do not want to run twice (once each for the INSERT and UPDATE), then insert the results temporarily into a GLOBAL TEMPORARY TABLE, and then run the INSERT and UPDATE statements off the GTT.
Ross Leishman

Report message to a moderator

Re: MERGE [message #190602 is a reply to message #190596] Thu, 31 August 2006 06:37 Go to previous message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
No. you have to use seperate DML for both INSERT and UPDATE

Report message to a moderator

Previous Topic: Query Not using Index
Next Topic: Complex results
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 13 06:04:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.