A year and a half ago I published a short article about apex 3.2 dictionary's new entries in comparison with version 3.1.
It's now the time to re-run those queries against Apex 4.0.1 and Apex 3.2.1.
Given the wealth of changes introduced with Apex 4.0.1, the total list of new columns exceeds 1200 rows, so i will only publish here the columns added to views that were existing in Apex 3.2, but of course you can run these queries on your own to see the full results.
The queries can be executed inside Apex SQL Workshop provided you haven't already dropped schema APEX_030200.
select view_name as new_view_name
from all_views
where owner = 'APEX_040000'
and view_name like 'APEX%'
minus
select view_name as new_view_name
from all_views
where owner = 'APEX_030200'
and view_name like 'APEX%';
NEW_VIEW_NAME
------------------------------
APEX_APPLICATION_PAGE_DA
APEX_APPLICATION_PAGE_DA_ACTS
APEX_APPLICATION_PAGE_FLASH5
APEX_APPLICATION_PAGE_FLASH5_S
APEX_APPLICATION_PAGE_IR_COMP
APEX_APPLICATION_PAGE_IR_GRPBY
APEX_APPLICATION_PAGE_IR_SUB
APEX_APPLICATION_PAGE_TREES
APEX_APPLICATION_TRANS_MAP
APEX_APPL_PLUGINS
APEX_APPL_PLUGIN_ATTRIBUTES
APEX_APPL_PLUGIN_ATTR_VALUES
APEX_APPL_PLUGIN_EVENTS
APEX_APPL_PLUGIN_FILES
APEX_DEBUG_MESSAGES
APEX_TEAM_BUGS
APEX_TEAM_FEATURES
APEX_TEAM_FEEDBACK
APEX_TEAM_FEEDBACK_FOLLOWUP
APEX_TEAM_MILESTONES
APEX_TEAM_TODOS
APEX_UI_DEFAULTS_ATTR_DICT
APEX_UI_DEFAULTS_GROUPS
APEX_WORKSPACE_LOG_ARCHIVE
APEX_WS_APPLICATIONS
APEX_WS_APP_PAGES
APEX_WS_DATA_GRID
APEX_WS_DATA_GRID_COL
28 rows selected
-- new columns (full list)
select b.table_name, b.column_name as new_column_name, b.comments
from
(select table_name, column_name
from all_tab_columns
where owner = 'APEX_040000'
and table_name like 'APEX%'
minus
select table_name, column_name
from all_tab_columns
where owner = 'APEX_030200'
and table_name like 'APEX%') a, all_col_comments b
where b.owner = 'APEX_040000'
and b.table_name = a.table_name
and b.column_name = a.column_name;
--------------------------------------------------
1221 rows selected (results omitted)
-- new columns added to existing views
select b.table_name, b.column_name, b.comments
from
(select table_name, column_name
from all_tab_columns
where owner = 'APEX_040000'
and table_name like 'APEX%'
minus
select table_name, column_name
from all_tab_columns
where owner = 'APEX_030200'
and table_name like 'APEX%') a, all_col_comments b
where b.owner = 'APEX_040000'
and b.table_name = a.table_name
and b.column_name = a.column_name
and b.table_name in (
select view_name
from all_views
where owner = 'APEX_030200'
and view_name like 'APEX%');
TABLE_NAME | COLUMN_NAME | COMMENTS |
---|---|---|
APEX_APPLICATIONS | AUTO_TIME_ZONE | Automatic time zone. Will derive the client time zone from the browser and set the database session timezone automatically at the beginning of each APEX session |
APEX_APPLICATIONS | DEFAULT_ERROR_DISPLAY_LOCATION | The default error display location identifies where validation error message will display. Messages can be displayed on an error page, or inline with the existing page. Inline validations are displayed in the "notification" area (defined as part of the page template), and/or within the item label. |
APEX_APPLICATIONS | PUBLISH | Display this application in a list of available applications |
APEX_APPLICATIONS | TIMESTAMP_FORMAT | Application default timestamp format. Will set NLS_TIMESTAMP_FORMAT prior to showing or posting a page |
APEX_APPLICATIONS | TIMESTAMP_TZ_FORMAT | Application default timestamp time zone format. Will set NLS_TIMESTAMP_TZ_FORMAT prior to showing or posting a page |
APEX_APPLICATION_LIST_ENTRIES | PRIMARY_APPLICATION_ID | |
APEX_APPLICATION_LIST_ENTRIES | TRANSLATED_APP_LANGUAGE | |
APEX_APPLICATION_LOV_ENTRIES | PRIMARY_APPLICATION_ID | |
APEX_APPLICATION_LOV_ENTRIES | TRANSLATED_APP_LANGUAGE | |
APEX_APPLICATION_PAGES | CREATED_BY | APEX developer who created the page. |
APEX_APPLICATION_PAGES | CREATED_ON | Date the page was created. |
APEX_APPLICATION_PAGES | JAVASCRIPT_CODE | Identifies Javascript code that replaces the #JAVASCRIPT_CODE# substitution string in the Page Template |
APEX_APPLICATION_PAGES | JAVASCRIPT_CODE_ONLOAD | Identifies JavaScript code which is executed after page load |
APEX_APPLICATION_PAGE_BUTTONS | EXECUTE_VALIDATIONS | Identifies if built-in validations and page validations should be executed when the page is submitted. |
APEX_APPLICATION_PAGE_IR | BASE_TABLE_OR_VIEW | Table or View used as the base for this interactive report region. |
APEX_APPLICATION_PAGE_IR | DETAIL_VIEW_AFTER_ROWS | Identifies the HTML to be displayed after report rows |
APEX_APPLICATION_PAGE_IR | DETAIL_VIEW_BEFORE_ROWS | Identifies the HTML to be displayed before report rows |
APEX_APPLICATION_PAGE_IR | DETAIL_VIEW_ENABLED_YN | Identifies that detail view is enabled and selectable from the interactive report |
APEX_APPLICATION_PAGE_IR | DETAIL_VIEW_FOR_EACH_ROW | Identifies the HTML to be displayed for each report row |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_ALT_TEXT | Identifies the HTML ALT text for the image. |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_COLUMNS_PER_ROW | Identifies the number of icons to be displayed per row |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_ENABLED_YN | Identifies that an icon view is enabled and selectable from the interactive report |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_IMG_ATTR_TEXT | Identifies the image attributes used for the HTML IMG tag. |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_IMG_SRC_COLUMN | Identifies the report column that returns the image source |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_LABEL_COLUMN | Identifies the report column that returns the image label |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_LINK_COLUMN | Identifies the report column that returns the link target of the icon |
APEX_APPLICATION_PAGE_IR | ICON_VIEW_TITLE_TEXT | Identifies the HTML TITLE tag for the image. |
APEX_APPLICATION_PAGE_IR | NUMBER_OF_ALT_DEFAULT_REPORTS | Number of developer-defined alternative default reports for this report region |
APEX_APPLICATION_PAGE_IR | NUMBER_OF_PRIVATE_REPORTS | Number of user-defined private reports for this report region |
APEX_APPLICATION_PAGE_IR | NUMBER_OF_PUBLIC_REPORTS | Number of user-defined public shared reports for this report region |
APEX_APPLICATION_PAGE_IR | REGION_NAME | Name of the interactive report region |
APEX_APPLICATION_PAGE_IR | SAVE_PUBLIC_AUTH_SCHEME | This authorization scheme must evaluate to TRUE in order for Public option to display in Save Report dialog |
APEX_APPLICATION_PAGE_IR | SAVE_PUBLIC_AUTH_SCHEME_ID | Foreign Key |
APEX_APPLICATION_PAGE_IR | SHOW_GROUP_BY | Determines whether to show the Group By option in the Actions Menu |
APEX_APPLICATION_PAGE_IR | SHOW_NOTIFY | Determines whether to show the Notify option in the Actions Menu |
APEX_APPLICATION_PAGE_IR | SHOW_REPORTS_SELECT_LIST | Determines whether saved reports are displayed as select list in the Search Bar. |
APEX_APPLICATION_PAGE_IR | SHOW_ROWS_PER_PAGE | Determines whether to show the Rows Per Page option in the Actions Menu |
APEX_APPLICATION_PAGE_IR | SHOW_SAVE_PUBLIC | Determines whether to show the Public option in the Save Report dialog |
APEX_APPLICATION_PAGE_IR_COL | ALLOW_GROUP_BY | Determines whether to allow group by for this column. |
APEX_APPLICATION_PAGE_IR_COL | ALLOW_HIDE | Determines whether to allow hiding this column. |
APEX_APPLICATION_PAGE_IR_COL | ALLOW_HIGHLIGHTING | Determines whether to allow highlighting for this column. |
APEX_APPLICATION_PAGE_IR_COL | COLUMN_EXPR | Attribute for internal use only |
APEX_APPLICATION_PAGE_IR_COL | COMPONENT_COMMENT | Developer Comment |
APEX_APPLICATION_PAGE_IR_COL | NAMED_LOV | Identifies the Shared List of Values to be used to display and filter this report column |
APEX_APPLICATION_PAGE_IR_COL | REGION_ID | ID of the interactive report region |
APEX_APPLICATION_PAGE_IR_COL | TZ_DEPENDENT | Column is time zone dependent |
APEX_APPLICATION_PAGE_IR_COND | CONDITION_ALLOW_DELETE | Identifies whether this condition can be deleted |
APEX_APPLICATION_PAGE_IR_COND | CONDITION_EXPR_TYPE | If expression is date/time, expression type is Value |
APEX_APPLICATION_PAGE_IR_COND | TIME_ZONE | Time zone of user's database session when condition was saved |
APEX_APPLICATION_PAGE_IR_RPT | COUNT_DISTNT_COL_ON_BREAK | Identifies which columns to aggregate with a count distinct |
APEX_APPLICATION_PAGE_IR_RPT | REPORT_ALIAS | An alternate alphanumeric report identifier to use in report link |
APEX_APPLICATION_PAGE_IR_RPT | REPORT_LINK_EXAMPLE | An example to link to specific saved reports |
APEX_APPLICATION_PAGE_ITEMS | AJAX_ITEMS_TO_SUBMIT | Identifies the page items which should be submitted when an AJAX call is performed for the page item. |
APEX_APPLICATION_PAGE_ITEMS | AJAX_OPTIMIZE_REFRESH | Yes or No, identifies if the AJAX call should be optimized. |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_01 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_02 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_03 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_04 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_05 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_06 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_07 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_08 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_09 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | ATTRIBUTE_10 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_ITEMS | DISPLAY_AS_CODE | Internal code of DISPLAY_AS |
APEX_APPLICATION_PAGE_ITEMS | ESCAPE_ON_HTTP_OUTPUT | If Yes values will be escaped when they are written to the HTTP output. |
APEX_APPLICATION_PAGE_ITEMS | IS_REQUIRED | If set to Yes, APEX will automatically perform a not null validation during page submit. |
APEX_APPLICATION_PAGE_ITEMS | LOV_CASCADE_PARENT_ITEMS | Identifies the cascading LOV parent item(s) for the item. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_01 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_02 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_03 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_04 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_05 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_06 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_07 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_08 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_09 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LABEL_10 | The label is the the text the end user of the application will see for the quick pick. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_LINK_ATTR | Link attribute which is added to each quick pick link. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_01 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_02 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_03 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_04 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_05 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_06 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_07 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_08 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_09 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | QUICK_PICK_VALUE_10 | The value defines the value which is used when the quick pick is clicked. |
APEX_APPLICATION_PAGE_ITEMS | SHOW_QUICK_PICKS | If set to Yes, the entered quick picks will be displayed below the page item. |
APEX_APPLICATION_PAGE_ITEMS | STANDARD_VALIDATIONS | Identifies where APEX will perform the built-in standard validations for the item type. |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_01 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_02 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_03 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_04 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_05 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_06 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_07 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_08 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_09 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | ATTRIBUTE_10 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_PROC | CONDITION_TYPE_CODE | Internal code of CONDITION_TYPE |
APEX_APPLICATION_PAGE_PROC | PROCESS_POINT_CODE | Internal code of PROCESS_POINT |
APEX_APPLICATION_PAGE_PROC | PROCESS_TYPE_CODE | Internal code of PROCESS_TYPE |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_01 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_02 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_03 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_04 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_05 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_06 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_07 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_08 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_09 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | ATTRIBUTE_10 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_REGIONS | DISPLAY_REGION_SELECTOR | |
APEX_APPLICATION_PAGE_REGIONS | LIST_ID | Associated list, if region is of type list. Can be joined to APEX_APPLICATION_LISTS. |
APEX_APPLICATION_PAGE_REGIONS | PARENT_REGION_ID | Identifies the region id of the parent region |
APEX_APPLICATION_PAGE_REGIONS | PARENT_REGION_NAME | Identifies the parent region |
APEX_APPLICATION_PAGE_REGIONS | REST_ENABLED | Identifies whether the region can be accessed via a RESTful call |
APEX_APPLICATION_PAGE_REGIONS | SOURCE_TYPE_CODE | Internal code of SOURCE_TYPE |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_01 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_02 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_03 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_04 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_05 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_06 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_07 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_08 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_09 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | ATTRIBUTE_10 | Dynamic attribute to store additional data |
APEX_APPLICATION_PAGE_RPT_COLS | DISPLAY_AS_CODE | Internal code of DISPLAY_AS |
APEX_APPLICATION_PAGE_RPT_COLS | IS_REQUIRED | If set to Yes, APEX will automatically perform a not null validation during page submit. |
APEX_APPLICATION_PAGE_RPT_COLS | STANDARD_VALIDATIONS | Identifies where APEX will perform the built-in standard validations for the report column type. |
APEX_APPLICATION_PAGE_VAL | ALWAYS_EXECUTE | If set to Yes this flag will overwrites the "Execute Validations" flag for buttons and always execute the validation. |
APEX_APPLICATION_PAGE_VAL | ASSOCIATED_COLUMN | If applicable, select the column associated with this validation error message. |
APEX_APPLICATION_PAGE_VAL | TABULAR_FORM_REGION_ID | Identifies the region ID of the tabular form region for column validations |
APEX_APPLICATION_PAGE_VAL | WHEN_BUTTON_PRESSED_ID | Foreign key to button |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_01 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_02 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_03 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_04 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_05 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_06 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_07 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_08 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_09 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | ATTRIBUTE_10 | Dynamic attribute to store additional data |
APEX_APPLICATION_PROCESSES | PROCESS_TYPE_CODE | Internal code of PROCESS_TYPE |
APEX_APPLICATION_TEMP_LIST | FIRST_LIST_TEMPLATE_CURRENT | First list template for current entry template. Defaults to list template current. |
APEX_APPLICATION_TEMP_LIST | FIRST_LIST_TEMPLATE_NONCURRENT | First list template for non current entry template. Defaults to list template non current. |
APEX_APPLICATION_TEMP_LIST | FITEM_TEMPLATE_NONCURR_W_CHILD | First item template for non current entry with child |
APEX_APPLICATION_TEMP_LIST | F_ITEM_TEMPLATE_CURR_W_CHILD | First item template for current entry with child |
APEX_APPLICATION_TEMP_REGION | SUB_REGION_HEADER_ENTRY_TEMPL | HTML that defined the appearance of a single sub region header entry |
APEX_APPLICATION_TEMP_REGION | SUB_REGION_HEADER_TEMPLATE | HTML that defined the appearance of a sub region header |
APEX_APPLICATION_TEMP_REGION | SUB_REGION_TEMPLATE | HTML that defined the appearance of a sub region |
APEX_APPLICATION_THEMES | DEFAULT_IRR_TEMPLATE | Identifies the default template when creating new components of a corresponding type |
APEX_APPLICATION_WEB_SERVICES | SOAP_VERSION | Identifies the SOAP version of the service, 1.1 or 1.2 |
APEX_DEVELOPER_ACTIVITY_LOG | OBJECT_NAME | The name of the affected component (stored at time of action) |
APEX_DEVELOPER_AUDIT_LOG | OBJECT_NAME | The name of the affected component (stored at time of action) |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_01 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_02 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_03 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_04 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_05 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_06 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_07 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_08 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_09 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | FORM_ATTRIBUTE_10 | When creating a form against this table or view, this dynamic attribute stores additional information for item type specified in display_as_form. |
APEX_UI_DEFAULTS_COLUMNS | GROUP_NAME | The group associated with this column. Will be used for creating regions in forms and groups in interactive reports. |
APEX_WORKSPACES | ALLOW_APP_BUILDING_YN | Controls availability of identified component |
APEX_WORKSPACES | ALLOW_SQL_WORKSHOP_YN | Controls availability of identified component |
APEX_WORKSPACES | ALLOW_TEAM_DEVELOPMENT_YN | Controls availability of identified component |
APEX_WORKSPACES | ALLOW_TO_BE_PURGED_YN | Controls availability of identified component |
APEX_WORKSPACES | ALLOW_WEBSHEET_DEV_YN | Controls availability of identified component |
APEX_WORKSPACES | SOURCE_IDENTIFIER | Identifies the workspace when data is synchronized to other systems. |
APEX_WORKSPACE_ACTIVITY_LOG | CONTENT_LENGTH | The size of the web page served. |
APEX_WORKSPACE_ACTIVITY_LOG | INTERACTIVE_REPORT_ID | Identifies the Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR view |
APEX_WORKSPACE_ACTIVITY_LOG | IR_SAVED_REPORT_ID | Identifies the Saved Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR_RPT view |
APEX_WORKSPACE_ACTIVITY_LOG | IR_SEARCH | The search text entered from Interactive Report search bar |
APEX_WORKSPACE_ACTIVITY_LOG | WS_APPLICATION_ID | Websheet application primary key, unique over all workspaces |
APEX_WORKSPACE_ACTIVITY_LOG | WS_DATAGRID_ID | ID of the Websheet application Data Grid |
APEX_WORKSPACE_ACTIVITY_LOG | WS_PAGE_ID | ID of the Websheet application page |
See more articles about Oracle Application Express or download tools and utilities.
2 comments:
Nice Job,
it's always good to have a difference when upgrading from one version to another.
Peter
thanks Peter,
actually it took me 10 minutes to assemble my article and almost an hour to figure out how to fix the layout owing to some bug (or feature?) of blogger that was arbitrarily adding line breaks between the preformatted paragraph and the last table.
Cheers
Post a Comment