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

关注

VIP免费原创最新推荐文章于 2026-02-18 01:27:17 发布 3.4k 阅读 AI 写同款· GEO 优化 ›

Oracle中创建存储过程、运行动态SQL并得到动态SQL语句所查询的值 create or replace procedure proc_getnewfuhebyfacid(fac_id_s in varchar2,fac_id_e in varchar2,newfuhe_s out varchar2,newfuhe_e out varchar2) is tempaclnid varchar2(20); temp_s_aclndotid varchar2(20); t 阅读详情

 ----------------------------------准备测试表和数据
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 INTO TUZHEN_TEST001 VALUES(10,'tuzhen003','LI_SHI','30');
INSERT INTO TUZHEN_TEST001 VALUES(11,'tuzhen005','DI_LI','41');
INSERT INTO TUZHEN_TEST001 VALUES(12,'tuzhen004','WU_LI','60');

SELECT * FROM TUZHEN_TEST001;