Oracle Merge Into µÄÓ÷¨Ïê½âʵÀý

Oracle merge into µÄÓ÷¨Ïê½âʵÀý
×÷Óãºmerge into ½â¾öÓÃB±í¸úÐÂA±íÊý¾Ý£¬Èç¹ûA±íÖÐûÓУ¬Ôò°ÑB±íµÄÊý¾Ý²åÈëA±í£»
Óï·¨£º
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATHED THEN [here you can execute some update sql or something else ]
WHEN NOT MATHED THEN [execute something else here ! ]
-------ʵÀý-------
merge into  a
using (select id,name from b ) c
on(a.id=c.id )
when matched then update set a.name=c.name
when not matched then insert (a.id,a.name) values (c.id,c.name);
×÷ÓãºÀûÓñí b ¸úбía £¬Ìõ¼þÊÇa.id=b.id£¬Èç¹ûa±íÖÐûÓиÃÌõ¼þµÄÊý¾Ý¾Í²åÈë¡£
Èç¹ûÄãµÄÊý¾ÝÁ¿ºÜ´ó£¬´ËsqlЧÂʷdz£¸ß¡£