-- Test.sql
DECLARE
V_COUNT NUMBER; 
BEGIN

SELECT NVL((CASE WHEN (  MAX(LAST_UPD_TMS) < SYSTIMESTAMP - INTERVAL '30' DAY)  THEN  1  END),0) 
INTO  V_COUNT 
FROM B;
IF V_COUNT > 0 THEN 
	TRUNCATE TABLE SNAPSHOTY_B;
	INSERT INTO SNAPSHOT_B SELECT * FROM PROCESS_WIP;
END IF;
END;

CREATE OR REPLACE PROCEDURE MF01.TEST( V_CNT OUT NUMBER)
AS
BEGIN
 
	SELECT NVL((CASE WHEN (  MAX(LAST_UPD_TMS) > SYSTIMESTAMP - INTERVAL '30' DAY)  THEN  1  END),0) INTO  V_CNT FROM B;
IF V_CNT > 0 THEN 
	EXECUTE IMMEDIATE 'TRUNCATE TABLE MF01.SNAPSHOT_B';
	INSERT INTO SNAPSHOT_B 
	SELECT * FROM B WHERE LAST_UPD_TMS < SYSTIMESTAMP - INTERVAL '30' DAY;
	COMMIT;
END IF;
END;