试一下？没有测试过

bl NUMBER : := 你那段sql;

 IF v_num !=2023 THEN

   select * from test3;

  ELSE

   select * from test1

   union all

   select * from test2

   union all

   select * from test3

  END IF;

CREATE OR REPLACE PROCEDURE P_TEST

AS

maxSj VARCHAR2(50);  

BEGIN

maxSj := SELECT MAX(SJ) AS SJ FROM TEST10086;

DELETE FROM TEST WHERE SJ = (SELECT MAX(SJ) AS SJ FROM TEST10086);

INSERT INTO TEST

WITH 

TEST1 AS 

( SELECT ID,DJ FROM A),

TEST2 AS 

( SELECT ID,DJ FROM B),

TEST3 AS 

( SELECT ID,DJ FROM C),

HZ AS 

(

IF maxSj != '2023'  THEN  

   SELECT * FROM TEST1

  ELSE  

SELECT * FROM TEST1

UNION ALL 

SELECT * FROM TEST2

UNION ALL 

SELECT * FROM TEST3 

  END IF; 

)

SELECT ID,SUM(DJ) FROM HZ GROUP BY ID;

END ;

在下面union 中的 test1 和 test2 中加条件  where case when max(Sj) <> '2023' then 2 else 1 end = 1 如果不等于2023 就给他弄个1=2 就查不出来东西