Oracle删除视图中的数据

最新推荐文章于 2024-07-24 06:39:49 发布

原创最新推荐文章于 2024-07-24 06:39:49 发布 · 2.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle

oracle 同时被 2 个专栏收录

14 篇文章

订阅专栏

存储过程

2 篇文章

订阅专栏

本文介绍了一个用于数据库操作的过程，该过程根据不同的类别参数从多个表中删除相应记录。主要涉及个体视图表中的数据，并根据类别分别在不同业务表中进行数据删除。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE OR REPLACE PROCEDURE "INDI_DEL_PRO" (IDPARA IN INDIVIDUALVIEW.ID%TYPE, CATEGORYPARA IN INDIVIDUALVIEW.CATEGORY%TYPE, RETURNPARA OUT NUMBER)
AS
APPLYNO INDIVIDUALVIEW.APPLY_NO%TYPE;
BEGIN
  SELECT COUNT(*) INTO RETURNPARA FROM INDIVIDUALVIEW WHERE ID=IDPARA AND CATEGORY=CATEGORYPARA;
  SELECT APPLY_NO INTO APPLYNO FROM INDIVIDUALVIEW WHERE ID=IDPARA AND CATEGORY=CATEGORYPARA;
  IF    CATEGORYPARA= '1001'THEN
        DELETE FROM SSC_EVECT_LOAN_INFO WHERE ID=IDPARA;
        DELETE FROM SSC_DAILY_LOAN_DETAIL_INFO WHERE ID=APPLYNO;
  ELSIF CATEGORYPARA= '1002'THEN
        DELETE FROM SSC_DAILY_LOAN_INFO WHERE ID=IDPARA;
  ELSIF CATEGORYPARA= '1003'THEN
        DELETE FROM SSC_EVECT_EXPENSE_INFO WHERE ID=IDPARA;
        DELETE FROM SSC_EVECT_EXPENSE_DETAIL_INFO WHERE ID=APPLYNO;
  ELSIF CATEGORYPARA= '1004'THEN
        DELETE FROM SSC_DAILY_EXPENSE_INFO WHERE ID=IDPARA;
        DELETE FROM SSC_DAILY_LOAN_DETAIL_INFO WHERE ID=APPLYNO;
  END IF;
END;