存储过程，比较两个表的数据

最新推荐文章于 2021-04-08 18:19:06 发布

navysuning

最新推荐文章于 2021-04-08 18:19:06 发布

阅读量1.2k

点赞数

文章标签：存储数据数据比对

本文链接：https://blog.csdn.net/navysuning/article/details/50434154

版权

创建了一个名为prc_liuhaijun01的存储过程，用于比对POL_REG_LCPOLTRANSACTION表与其他四个表（POL_REG_LCBNF, POL_REG_LCCONT, POL_REG_LCPRODINSURELA, POL_REG_LCPRODUCT）的transactionno字段，找出不一致的数据并插入到temp_liuhaijun临时表中。" 126061861,12674255,MySQL唯一约束详解与应用,"['数据库', '后端开发', 'SQL']

摘要由CSDN通过智能技术生成

--存储过程
--POL_REG_LCPOLTRANSACTION分别与POL_REG_LCCONT，POL_REG_LCPRODINSURELA，POL_REG_LCPRODUCT，POL_REG_LCBNF比较
CREATE OR REPLACE PROCEDURE prc_liuhaijun01 AS
cnt_a NUMBER;
cnt_b NUMBER;
cnt_c number;
cnt_d number;

TYPE ab IS RECORD(
a_transactionno POL_REG_LCPOLTRANSACTION.transactionno%TYPE,
b_transactionno POL_REG_LCBNF.transactionno%TYPE,
c_transactionno POL_REG_LCCONT.TRANSACTIONNO%TYPE,
d_transactionno POL_REG_LCPRODINSURELA.TRANSACTIONNO%TYPE,
e_transactionno POL_REG_LCPRODUCT.TRANSACTIONNO%TYPE);
rs ab;
CURSOR cur IS
SELECT *
FROM (SELECT a.transactionno AS a_transactionno,
b.transactionno AS b_transactionno,
c.transactionno AS c_transactionno,
d.transactionno AS d_transactionno,