----------------------------------准备测试表和数据
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
Oracle 存储过程 动态SQL 语句 返回结果集
最新推荐文章于 2024-04-11 10:46:46 发布
本文介绍了如何在Oracle中创建一个存储过程,该过程使用动态SQL语句根据输入参数聚合数据并返回结果集。通过示例展示了如何定义存储过程、执行SQL命令以及调用存储过程输出结果。
摘要由CSDN通过智能技术生成