What's new in Apex 3.2 dictionary?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

In case you are wondering what's new inside the apex 3.2 data dictionary, the following query run from SQL Workshop will quickly return the desired answer.

select table_name, column_name from all_tab_columns
where owner = 'APEX_030200'
and table_name like 'APEX%'
minus
select table_name, column_name from all_tab_columns
where owner = 'FLOWS_030100'
and table_name like 'APEX%';

The following query will also return the comments alongside.

select b.table_name, b.column_name, b.comments
from
(select table_name, column_name
  from all_tab_columns
where owner = 'APEX_030200'
and table_name like 'APEX%'
minus
select table_name, column_name
 from all_tab_columns
where owner = 'FLOWS_030100'
and table_name like 'APEX%') a, all_col_comments b
where b.owner = 'APEX_030200'
and b.table_name = a.table_name
and b.column_name = a.column_name;

The SQL queries above work on the assumption that you have not dropped the schema FLOWS_030100 after upgrading to Apex 3.2.
Note also that as of Apex 3.2 the apex repository schema name prefix has changed from the "historic" FLOWS to APEX.

See more articles about Oracle Application Express or download tools and utilities.