可以用merge试试,类似这样 SQL> select * from test_merge; ID NAME AGE ---------- -------------------- ---------- 1 aaa 30 2 bbb 10SQL> merge into test_merge a 2 using (select 'zxf' name from dual ) b 3 on (a.name=b.name) 4 when not matched then 5 insert values(3,'zxf',12) 6 when matched then 7 update set age=30;1 行已合并。SQL> select * from test_merge; ID NAME AGE ---------- -------------------- ---------- 1 aaa 30 2 bbb 10 3 zxf 12
把问题能描述的清楚一些么,对你的要求不是很明白。count也可以判断呀,
SELECT nvl2(ACCSSPTNAME,1,0) FORM ACCESSERINFO where ACCSSPTNAME='"+ AccssPtName+"' ACCSSPTNAME 为非空时, 返回1,否则,返回0
字段PTNAME, PTNUM, NAME, NUM, STATUS, TRBLFLAG
列PTNAME如果有这条数据就进行修改如果没有就插入数据
怎么实现啊
SQL> select * from test_merge; ID NAME AGE
---------- -------------------- ----------
1 aaa 30
2 bbb 10SQL> merge into test_merge a
2 using (select 'zxf' name from dual ) b
3 on (a.name=b.name)
4 when not matched then
5 insert values(3,'zxf',12)
6 when matched then
7 update set age=30;1 行已合并。SQL> select * from test_merge; ID NAME AGE
---------- -------------------- ----------
1 aaa 30
2 bbb 10
3 zxf 12
把问题能描述的清楚一些么,对你的要求不是很明白。count也可以判断呀,
ACCSSPTNAME 为非空时, 返回1,否则,返回0