Oracle/PLSQL: OPEN Statement

 

Oracle/PLSQL: OPEN Statement

---

Once you've declared your cursor, the next step is to open the cursor.

译：在你定义好一个游标后，下一步就是打开该游标。

The basic syntax to OPEN the cursor is:

OPEN cursor_name;

 

For example, you could open a cursor called c1 with the following command:

译：例如，你可以使用如下命令打开一个名为 c1 有游标：

OPEN c1;

 

Below is a function that demonstrates how to use the OPEN statement:

译：下面是一个演示如何例用 OPEN 的方法：

CREATE OR REPLACE Function FindCourse
   ( name_in IN varchar2 )
   RETURN number
IS
    cnumber number;

    CURSOR c1
    IS
       SELECT course_number
        from courses_tbl
        where course_name = name_in;

BEGIN

open c1;
fetch c1 into cnumber;

if c1%notfound then
     cnumber := 9999;
end if;

close c1;

RETURN cnumber;

END;