Saturday, January 5, 2019

How to list APEX Dictionary views using S

I hope this isn’t old news but it seems that whenever someone talks about the APEX dictionary they talk about going into the development application and viewing them there. You can also access the dictionary using SQL. Here’s how:

select * from apex_dictionary where column_id=0
select distinct apex_view_name from apex_dictionary
    Of course you can remove the “where column_id=0” portion and get a list of the all the columns for the views etc.

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...