- 1、本文档共30页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
pl_sql中的游标操作(Cursor operations in pl_sql)
pl_sql中的游标操作(Cursor operations in pl_sql)
/ *
Cursor (pointer, pointer to the head of the result set)
In pl/SQL, it is used to traverse the result set of a multi-row record
The cursor moves one way and does not remove the boundary. If it has moved to the end of the result set, the cursor always points to the last record
Classification of cursors
Explicit cursor
Implicit cursor
Dynamic cursors
* /
/ *
Explicit cursor (the select query corresponding to the cursor is fixed)
define
Cursor cursor name is query statement; (read only cursor)
The cursor begins with cur_
Your cursor
1. Open cursor name;
2. Loop loop (loop, while, for)
Get the data from the cursor
The fetch directive moves the pointer down to get a row of data pointing to the current pointer
Fetch cursor name into variable;
The cursor has 4 commonly used properties (with initialization value false false 0 false) (read-only property)
% FOUND - TRUE
% NOTFOUND - when the % NOTFOUND attribute of the cursor is TRUE, the result set that the current cursor points to is in the tail
% ROWCOUNT - the number of rows represented by the % ROWCOUNT of the cursor (the number of rows moved by the cursor)
The % ISOPEN - cursor is open, always FALSE
Remember to close the cursor after use
Close cursor name;
* /
- iterate over all the employee information in the emp table
declare
Define explicit cursors
Cursor cur_emp is select * from emp;
V_emp emp % rowtype;
The begin
The open cur_emp;
-- iterate over the cursor
- loop cycle
/ *
loop
The fetch cur_emp into v_emp;
Exit the when cur_emp % notfound;
-- write business code
Dbms_output. Put_line ( serial number: | | cur_emp % rowcount | | employee number: | | v_emp. Empno | |, employee name: | | v_emp, ename | |, engaged in position: | | v_emp. The job);
End loop;
* /
Dbms_output. Put_line (cur_emp % rowcount);
If cur_emp % notfound then
Dbms_output. Put_line ( true );
The else
Dbms_output. Put_line ( false );
End the if;
If cur_emp % found then
Dbms_output. Put_line ( true );
The
您可能关注的文档
- 2013年全国会计从业考试《会计基础》判断题及答案(In 2013, the national accounting practice examination basic accounting and the answer).doc
- 2013年助理物流师考试单选模拟题一及答案(In 2013, the assistant logistics division test one and the answer).doc
- 2013年公路工程试验检测试卷库(2013 highway engineering test examination paper library).doc
- 2013年武汉市九年级4月调考物理试题及答案(In 2013, the physics test and the answer were taken in the ninth grade of wuhan city).doc
- 2013年华师马克思主义基本原理概论作业(The basic principle of Chinese marxism in 2013).doc
- 2013年板块龙头股速览(In 2013, we have a quick overview of the sector).doc
- 2013年福师《中国古代史专题》在线作业一(In 2013, fushi Chinese ancient history special topics online work 1).doc
- 2013年英语考试大纲新增的60个词汇详解(There are 60 new words for the English test syllabus in 2013).doc
- 2013最新衡水公交车路线图(The new hengshui bus route 2013).doc
- 2013最新超全个性签名(Latest super personality signature in 2013).doc
- 2023年07月云南昆明市劳动人事争议仲裁院编外聘用人员公开招聘2人笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 2023年07月云南大理大学第二批公开招聘硕士及以上人员28人笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 2023年07月下半年国家税务总局黑龙江省税务局事业单位公开招聘112人笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 2023年07月云南大理祥云县投资项目服务中心急需紧缺人才引进1人笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 2023年07月中共南宁市青秀区纪律检查委员会公开招聘2人(广西)笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 2023年07月内蒙古自治区文学艺术界联合会事业单位公开招聘3人笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 2023年07月内蒙古呼伦贝尔市扎赉诺尔区事业单位综合类岗位引进人才76人笔试上岸试题历年高频考点难、易错点摘选附带答案详解.docx
- 《万物简史》读后感600字.docx
- 郑州南四环至郑州南站城郊铁路工程一期工程土建施工05标段施工组织设计.pdf
- 《核舟记》读后感600字.docx
文档评论(0)