hawkzhan
- 浏览: 3020 次
-
最新评论
文章列表
http://topic.csdn.net/u/20100304/13/0a752c18-c083-4102-901d-2134870adedd.html?30360
MERGE INTO tvsms.vsms_goods_t a
USING ( select '44467890' goods_id,'10' goods_suttle,'assadf' goods_pname from dual) c
ON (c.goods_id=a.goods_id)
WHEN MATCHED THEN
update set GOODS_SUTTLE=c.goods_suttle,goods_time=sysdate,GOODS_PNAME=c.goods_pname
where a.goods_id=c.goods_id
WHEN N ...