| ORACLE V7.0中游标的研究与分析 |
| |
| 引用本文： | 谢鹏. ORACLE V7.0中游标的研究与分析[J]. 西安石油大学学报(自然科学版), 1997, 0(3) |
| |
| 作者姓名： | 谢鹏 |
| |
| 作者单位： | 西安石油学院计算机系 |
| |
| 摘 要： | ＳＱＬ语言是国际标准化组织（ＩＳＯ）于１９８６年公布的关系数据库语言，因此对ＳＱＬ语言深入研究有重要的应用价值．ＯＲＡＣＬＥ数据库采用的ＰＬ／ＳＱＬ语言中最主要最核心的ＳＥ－ＬＥＣＴ类语句的查询结果是记录的集合而不是单个记录，为此需要游标机制作为桥梁，把集合转换为单记录处理．笔者论述了ＯＲＡＣＬＥＶ７．０中游标的概念、定义方法和使用过程，说明了游标的属性及其在游标打开、访问、关闭前后的变化状态，并举例说明了这些变化的属性及其使用方法．
|
| 关 键 词： | 计算机程序设计语言，数据库／［活动区，游标属性］ |
Study and Analysis of the Cursor in ORACLE V7.0 |
| |
| Xie Peng. Study and Analysis of the Cursor in ORACLE V7.0[J]. Journal of Xian Shiyou University, 1997, 0(3) |
| |
| Authors: | Xie Peng |
| |
| Abstract: | SQL is a relation database language promulgated by ISO (International Standard Organization) in 1986. It is necessary to make a thorough study of it.Select sentence is a key sentence of PL/SQL in ORACLE database,and its inquiry result is a set of records and not a single record.As the inquired records are processed one by one,it is essential to separate the set of records by means of a cursor.This paper discusses the concept,the definition method and the using process of the cursor in ORACLE V7.0. |
| |
| Keywords: | free words]:computer programing language database/[cursor active set attribute] |
| 本文献已被 CNKI 等数据库收录！ |
