![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
bign2013
这个作者很懒,什么都没留下…
展开
-
oracle游标打开方式
CURSOR cur1 IS SELECT a,b,c FROM dual; SELECT 语句可以是多个表,视图 方式一:打开游标,开始循环,从游标中取值,那一行被返回,处理,关闭循环,关闭游标 open cur1 loop --循环游标 fetch cur1 into v_a,v_b,v_c;--提取数据,一次返回指...原创 2012-07-26 12:45:39 · 854 阅读 · 0 评论 -
【转】记录一下oracle中的schema
首先,可以先看一下schema和user的定义: A schema is a collection of database objects (used by a user). Schema objects are the logical structures that directly refer to the database’s data. A user is a name define...原创 2012-08-08 22:53:45 · 69 阅读 · 0 评论