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
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: 3724
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
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
Previous Topic: Query Not using Index
Next Topic: Complex results
Goto Forum:
  


Current Time: Sun Dec 04 12:51:01 CST 2016

Total time taken to generate the page: 0.07445 seconds