Oracle 18c

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

CREATE TABLE table1 (created_on) AS
SELECT SYSDATE - LEVEL FROM DUAL CONNECT BY LEVEL <= 3;
3 rows affected

CREATE TABLE table2 (created_on) AS
SELECT SYSDATE - LEVEL FROM DUAL CONNECT BY LEVEL <= 3;
3 rows affected

CREATE TABLE "table3" (created_on) AS
SELECT SYSDATE - LEVEL FROM DUAL CONNECT BY LEVEL <= 3;
3 rows affected

CREATE TABLE table5 (created_on) AS
SELECT SYSDATE FROM DUAL;
1 rows affected

DECLARE
  v_tables SYS.ODCIVARCHAR2LIST := SYS.ODCIVARCHAR2LIST(
    'TABLE1', 'TABLE2', 'table3', 'TABLE5'
  );
  v_sql CLOB := 'CREATE OR REPLACE VIEW last_dates (table_name, last_date) AS ';
BEGIN
  FOR i in 1 .. v_tables.COUNT LOOP
    IF i > 1 THEN
      v_sql := v_sql || ' UNION ALL ';
    END IF;
    v_sql := v_sql || 'SELECT '
                   || DBMS_ASSERT.ENQUOTE_LITERAL(v_tables(i))
                   || ', MAX(created_on) FROM '
                   || DBMS_ASSERT.ENQUOTE_NAME(v_tables(i), FALSE);
  END LOOP;
  
  EXECUTE IMMEDIATE v_sql;
END;
/
1 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
SELECT * FROM last_dates;


TABLE_NAME
LAST_DATE


TABLE1
2021-12-13 13:22:53

TABLE2
2021-12-13 13:22:53

table3
2021-12-13 13:22:53

TABLE5
2021-12-14 13:22:53

TABLE_NAME	LAST_DATE
TABLE1	2021-12-13 13:22:53
TABLE2	2021-12-13 13:22:53
table3	2021-12-13 13:22:53
TABLE5	2021-12-14 13:22:53