Oracle APEX Metadata Views
•APEX Views are data dictionary views that expose the metadata for applications.
•There are two ways of getting the view names :
•1. App Builder à Workspace Utilities à Oracle APEX Views
2.Using DB View : apex_dictionary
select * from apex_dictionary where column_id =0;