Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t(Id INT, Val varchar2(50));
INSERT INTO t(Id, Val)
SELECT 10, 'a' FROM dual
UNION ALL SELECT 20,'b' FROM dual
UNION ALL SELECT 30, 'a' FROM dual
UNION ALL SELECT 40,'b' FROM dual
4 rows affected

SELECT * FROM t;


ID
VAL


10
a

20
b

30
a

40
b


DECLARE
   l_cnt INT;
BEGIN
   DELETE FROM t RETURNING COUNT(*) INTO l_cnt;
   DBMS_OUTPUT.put_line('l_cnt: ' || l_cnt);
END;
//
1 rows affected

dbms_output:
l_cnt: 4

INSERT INTO t
SELECT 10, 'a' FROM dual
UNION ALL SELECT 20,'b' FROM dual
UNION ALL SELECT 30, 'a' FROM dual
UNION ALL SELECT 40,'b' FROM dual
4 rows affected

DECLARE
   l_max INT;
   l_min INT;
   l_str VARCHAR2(100);
BEGIN
   DELETE FROM t 
   RETURNING MAX(id), MIN(id), LISTAGG(id, ',') WITHIN GROUP(ORDER BY id) INTO l_max, l_min, l_str;
   DBMS_OUTPUT.put_line('l_max:' || l_max || ' l_min:' || l_min || ' l_str:' || l_str);
END;
//
1 rows affected

dbms_output:
l_max:40 l_min:10 l_str:10,20,30,40

INSERT INTO t
SELECT 10, 'a' FROM dual
UNION ALL SELECT 20,'b' FROM dual
UNION ALL SELECT 30, 'a' FROM dual
UNION ALL SELECT 40,'b' FROM dual
4 rows affected

DECLARE
   l_distinct_cnt INT;
BEGIN
   DELETE FROM t 
   RETURNING COUNT(DISTINCT val) INTO l_distinct_cnt ;
   DBMS_OUTPUT.put_line('l_distinct_cnt' || l_distinct_cnt );
END;
//
ORA-00934: group function is not allowed here
ORA-06512: at line 4