Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


CREATE TABLE NAME_TABLE (Id NUMBER, Name VARCHAR2 (16), Calc_Date DATE)
CREATE TABLE NAME_TABLE1 (Id, Name) AS
    SELECT 1, 'NAME' FROM DUAL 
1 rows affected

DECLARE
  l_Cnt_Del NUMBER;
BEGIN
  INSERT --+ append
  INTO NAME_TABLE
  SELECT Cvm.*, Trunc(SYSDATE) Calc_Date 
  FROM NAME_TABLE1 Cvm;
  DELETE FROM NAME_TABLE Cvh
  WHERE Cvh.Calc_Date < Trunc(SYSDATE) - 14;
  l_Cnt_Del := SQL%ROWCOUNT;
  COMMIT;
END;
/
ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at line 8