![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DML
caidan250
这个作者很懒,什么都没留下…
展开
-
Oracle 之 update 例子
Oracle 之 update 例子update bbset (bb.col1,bb.col2)=(select aa.col1,aa.col2 from aa where bb.key=aa.forkey)where exists(select 1 from aa where bb.key=aa.forkey)原创 2019-04-10 11:00:05 · 201 阅读 · 0 评论 -
Oracle 之 cursor 游标
declarev_col1 table.col1%type;cursor cur is select col1 from table where 1=1 ;beginopen cur;loopfetch cur into v_col1;exit when cur%notfound;– doingend loop;close cur ;end;原创 2019-04-10 11:07:00 · 529 阅读 · 0 评论