-- Start
利用游标表达式,我们可以返回嵌套游标。
CREATE TABLE Class (
ClassName VARCHAR2(10)
);
INSERT INTO Class VALUES ('116班');
CREATE TABLE Student(
Id INT NOT NULL,
Name VARCHAR2(30) NOT NULL,
ClassName VARCHAR2(10)
);
INSERT INTO Student VALUES (1, '张三', '116班');
INSERT INTO Student VALUES (2, '李四', '116班');
INSERT INTO Student VALUES (3, '王五', '117班');
DECLARE
ClassName VARCHAR2(10);
StudentName VARCHAR2(10);
StudentCurVar SYS_REFCURSOR;
CURSOR c1 IS
SELECT
ClassName,
CURSOR (S