Oracle 存储过程 动态SQL 语句 返回结果集

 ----------------------------------准备测试表和数据
CREATE TABLE TUZHEN_TEST001 
(
  ID NUMBER 
, XINGMING VARCHAR2(100) 
, KECHENG VARCHAR2(100) 
, FENSHU NUMBER 
);

INSERT INTO TUZHEN_TEST001 VALUES(1,'tuzhen001','YU_WEN','87');
INSERT INTO TUZHEN_TEST001 VALUES(2,'tuzhen001','SHU_XUE','88');
INSERT INTO TUZHEN_TEST001 VALUES(3,'tuzhen001','YING_YU','89');
INSERT INTO TUZHEN_TEST001 VALUES(4,'tuzhen002','YU_WEN','90');
INSERT INTO TUZHEN_TEST001 VALUES(5,'tuzhen002','SHU_XUE','91');
INSERT INTO TUZHEN_TEST001 VALUES(6,'tuzhen002','YING_YU','92');

INSERT INTO TUZHEN_TEST001 VALUES(7,'tuzhen003','YU_WEN','30');
INSERT INTO TUZHEN_TEST001 VALUES(8,'tuzhen003','SHU_XUE','41');
INSERT INTO TUZHEN_TEST001 VALUES(9,'tuzhen004','YING_YU','60');

INSERT I