Oracle APEX is providing a dictionary view called APEX_DICTIONARY which is returning names and comments for all other dictionary vies.
For example:
SELECT *
FROM apex_dictionary
;
A result:
So, rows with column ID 0 contain a view name and other rows with numbers >= 1 contain column names.
