把查询出来的结果插入到另一张表中:
CREATE OR REPLACE PROCEDURE TELEPATHOLOGY_TEST_DATA IS BEGIN
FOR row_data IN (
SELECT
bpi.APPLY_NO AS TELME_ASK_NUM,-- 申请单编号
-- 各种查询字段
FROM
--表名
WHERE
-- 条件
)
LOOP
INSERT INTO TELEPATHOLOGY_TEST_DIAGNOSIS (
LAST_UPDATE_DTIME,
-- 插入的字段名
)
VALUES
(
row_data.LAST_UPDATE_DTIME,
-- 具体值
);
COMMIT;
END LOOP;
END TELEPATHOLOGY_TEST_DATA;
如果是spring boot调用存储过程,和之前写的文章类似。
SpringBoot调用Oracle存储过程(入参,出参)_我会敲代码哦!的博客-CSDN博客_springboot 调用oracle存储过程-spring boot+mybatis调用Oracle存储过程https://blog.csdn.net/weixin_53818213/article/details/126221573------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------