1 person found this helpful
No, we do not provide documentation on the APEX_XXXXXX tables, as we do not recommend direct references to those tables. We provide a suite of views, which we recommend customers use. Each column referenced in the documented views are commented. As mentioned in section 18.104.22.168 Accessing Application Express Views in the APEX 5.0 User's Guide, you can access the views via the Application Builder > Utilities > Application Express Views page.
I hope this helps.
Helps a lot. Thank you.
Also note that the views are extensively documented in the APEX_DICTIONARY "meta-metadata "view:
select * from apex_dictionary [where apex_view_name = '<view name>']
I would like to add that those views are based on wwv_ tables from the apex user.
I know is not recommended to access them, but there are very -extra- special cases in which could be needed.