Posts

Showing posts from February, 2014

Finding components with a particular build option

Say for example you have a generic build status of 'Exclude' - so you can temporarily disable components without touching the conditions (it doesn't really seem in the nature of build options, but still can be done). There will undoubtedly come a time where you need to locate all said components to either remove them from the application, or remove the build option so they are re-included. First we can query the apex_dictionary view to find any views that contain the build option column: select * from apex_dictionary where column_name = 'BUILD_OPTION' As at ApEx 4.2, this gives us the following list: APEX_APPL_USER_INTERFACES APEX_APPLICATION_BC_ENTRIES APEX_APPLICATION_COMPUTATIONS APEX_APPLICATION_ITEMS APEX_APPLICATION_LISTS APEX_APPLICATION_LIST_ENTRIES APEX_APPLICATION_LOV_ENTRIES APEX_APPLICATION_NAV_BAR APEX_APPLICATION_PAGES APEX_APPLICATION_PAGE_BRANCHES APEX_APPLICATION_PAGE_COMP APEX_APPLICATION_PAGE_DA APEX_APPLICATION_PAGE_PROC A

SQL Developer Configuration

Can be found here: ~/.sqldeveloper/4.0.0/product.conf