条件插入
merge   into   bd_userrole   a  
using   (select   '10 '   as   roleid, '0105 '   as   userid   from   dual)   b    
on   (   a.burbrid   =b.roleid     and   a.burempid=b.userid   )
when   not   matched   then   insert   (a.burbrid,a.burempid)   values     (b.roleid,b.userid)
when   matched   then  
      --do   nothing
想要达到这种目标怎么办才好

执行的时候老是出   "A ". "BURBRID ":无效的标识符，怎么看都不明白为什么




------解决方案--------------------
create table t1(cid int,cname varchar2(100));
insert into t1 values (1, '1 ');
create table t2(cid int,cname varchar2(100));
insert into t2 values(1, '3 ');
insert into t2 values(2, '4 ');
--执行语句
MERGE INTO t1 a
USING t2 b
on (a.cid=b.cid)
WHEN MATCHED THEN
UPDATE SET a.cname=b.cname
WHEN NOT MATCHED THEN
INSERT (a.cid,a.cname ) VALUES ( b.cid,b.cname );
--执行结果
select * from t1

13
24
------解决方案--------------------
create table t1(cid int,cname varchar2(100));
insert into t1 values (1, '1 ');
create table t2(cid int,cname varchar2(100));
--执行语句
MERGE INTO t1 a
USING (select '1 ' cid, '3 ' cname from dual) b
on (a.cid=b.cid)
WHEN MATCHED THEN
UPDATE SET a.cname=b.cname
WHEN NOT MATCHED THEN
INSERT (a.cid,a.cname ) VALUES ( b.cid,b.cname );
--执行结果
select * from t1

1 3

------解决方案--------------------
要么把你的表结构和测试数据和输出结果发出来
------解决方案--------------------
学习中!
------解决方案--------------------
top