Oracle 11g Release 2

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

CREATE TABLE abc (a, b, c, d, e) AS
SELECT LEVEL, LEVEL, LEVEL, LEVEL, LEVEL FROM DUAL CONNECT BY LEVEL <= 42;
42 rows affected

CREATE table stats (
  table_name VARCHAR2(128),
  num_rows NUMBER,
  num_cols NUMBER 
);
DECLARE
  val integer;
BEGIN
  FOR i IN (
    SELECT table_name,
           COUNT(*) AS num_cols
    FROM   all_tab_cols
    WHERE  owner = USER
    GROUP BY table_name
  )
  LOOP
    EXECUTE IMMEDIATE 'SELECT count(*) from ' || i.table_name INTO val;
    INSERT INTO stats VALUES (i.table_name,val, i.num_cols);
  END LOOP;
END;
/
1 rows affected

SELECT * FROM stats;


TABLE_NAME
NUM_ROWS
NUM_COLS


STATS
0
3

ABC
42
5