By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TYPE string_list IS TABLE OF VARCHAR2(128);
DECLARE
table_names string_list := string_list('TABLE_1', 'TABLE_2', 'TABLE_3');
arrayvalues_table string_list;
BEGIN
SELECT DISTINCT
table_name
BULK COLLECT INTO arrayvalues_table
FROM user_tab_columns
WHERE table_name MEMBER OF ( table_names );
END;
/
1 rows affected