第11讲3--游标Cursor.pdf
《第11讲3--游标Cursor.pdf》由会员分享,可在线阅读,更多相关《第11讲3--游标Cursor.pdf(16页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、An Introduction to Database System Video 11-3?Cursor An Introduction to Database System ? ? ? ? ?SQL? ? ? ? ? ?SQL? ? An Introduction to Database System ? ? ? ? SQL? ? SQL?SQL? ? ? ? ? ?SQL? ? ? ?SQL? An Introduction to Database System ?SQL? ?SQL? ?SELECT? ?CURRENT?UPDATE? ?CURRENT?DELETE? An Introd
2、uction to Database System 1. ?SELECT? ? ?1? ?2? ?3? ?4? An Introduction to Database System ?1? ? ?DECLARE? ? ? EXEC SQL DECLARE CURSOR FOR ; ? ? ?SELECT? ?select? ? An Introduction to Database System ?2? ? ?OPEN? ? ? EXEC SQL OPEN ; ? ? ?SELECT? ? ? An Introduction to Database System ?3? ? ?FETCH? ?
3、 ? EXEC SQL FETCH INTO ,.; ? ? ? ? An Introduction to Database System ?4? ? ?CLOSE? ? ? EXEC SQL CLOSE ; ? ? ? ? ? ? ? An Introduction to Database System 2. CURRENT?UPDATE/DELETE? ? ?CURRENT?UPDATE?DELETE? ? ? ? ?CURRENT?UPDATE?DELETE? ? ? An Introduction to Database System CURRENT?UPDATE/DELETE? ?
4、CURRENT?UPDATE?DELETE? ? ? ? ?SELECT? ? ?CURRENT?UPDATE?DELETE? ? ?UPDATE?DELETE? WHERE CURRENT OF ? ? An Introduction to Database System CURRENT?UPDATE?DELETE? ? ?CURRENT?UPDATE?DELETE? ? ?SELECT?UNION?ORDER BY? ? ?SELECT? ? ? ? An Introduction to Database System 3. ? ? ?8.1 ? EXEC SQL BEGIN DECLAR
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 11 游标 Cursor
限制150内