Thursday, October 07, 2010

What's new in Apex 4.0 dictionary?

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

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_NAMECOLUMN_NAMECOMMENTS
APEX_APPLICATIONSAUTO_TIME_ZONEAutomatic 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_APPLICATIONSDEFAULT_ERROR_DISPLAY_LOCATIONThe 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_APPLICATIONSPUBLISHDisplay this application in a list of available applications
APEX_APPLICATIONSTIMESTAMP_FORMATApplication default timestamp format. Will set NLS_TIMESTAMP_FORMAT prior to showing or posting a page
APEX_APPLICATIONSTIMESTAMP_TZ_FORMATApplication default timestamp time zone format. Will set NLS_TIMESTAMP_TZ_FORMAT prior to showing or posting a page
APEX_APPLICATION_LIST_ENTRIESPRIMARY_APPLICATION_ID
APEX_APPLICATION_LIST_ENTRIESTRANSLATED_APP_LANGUAGE
APEX_APPLICATION_LOV_ENTRIESPRIMARY_APPLICATION_ID
APEX_APPLICATION_LOV_ENTRIESTRANSLATED_APP_LANGUAGE
APEX_APPLICATION_PAGESCREATED_BYAPEX developer who created the page.
APEX_APPLICATION_PAGESCREATED_ONDate the page was created.
APEX_APPLICATION_PAGESJAVASCRIPT_CODEIdentifies Javascript code that replaces the #JAVASCRIPT_CODE# substitution string in the Page Template
APEX_APPLICATION_PAGESJAVASCRIPT_CODE_ONLOADIdentifies JavaScript code which is executed after page load
APEX_APPLICATION_PAGE_BUTTONSEXECUTE_VALIDATIONSIdentifies if built-in validations and page validations should be executed when the page is submitted.
APEX_APPLICATION_PAGE_IRBASE_TABLE_OR_VIEWTable or View used as the base for this interactive report region.
APEX_APPLICATION_PAGE_IRDETAIL_VIEW_AFTER_ROWSIdentifies the HTML to be displayed after report rows
APEX_APPLICATION_PAGE_IRDETAIL_VIEW_BEFORE_ROWSIdentifies the HTML to be displayed before report rows
APEX_APPLICATION_PAGE_IRDETAIL_VIEW_ENABLED_YNIdentifies that detail view is enabled and selectable from the interactive report
APEX_APPLICATION_PAGE_IRDETAIL_VIEW_FOR_EACH_ROWIdentifies the HTML to be displayed for each report row
APEX_APPLICATION_PAGE_IRICON_VIEW_ALT_TEXTIdentifies the HTML ALT text for the image.
APEX_APPLICATION_PAGE_IRICON_VIEW_COLUMNS_PER_ROWIdentifies the number of icons to be displayed per row
APEX_APPLICATION_PAGE_IRICON_VIEW_ENABLED_YNIdentifies that an icon view is enabled and selectable from the interactive report
APEX_APPLICATION_PAGE_IRICON_VIEW_IMG_ATTR_TEXTIdentifies the image attributes used for the HTML IMG tag.
APEX_APPLICATION_PAGE_IRICON_VIEW_IMG_SRC_COLUMNIdentifies the report column that returns the image source
APEX_APPLICATION_PAGE_IRICON_VIEW_LABEL_COLUMNIdentifies the report column that returns the image label
APEX_APPLICATION_PAGE_IRICON_VIEW_LINK_COLUMNIdentifies the report column that returns the link target of the icon
APEX_APPLICATION_PAGE_IRICON_VIEW_TITLE_TEXTIdentifies the HTML TITLE tag for the image.
APEX_APPLICATION_PAGE_IRNUMBER_OF_ALT_DEFAULT_REPORTSNumber of developer-defined alternative default reports for this report region
APEX_APPLICATION_PAGE_IRNUMBER_OF_PRIVATE_REPORTSNumber of user-defined private reports for this report region
APEX_APPLICATION_PAGE_IRNUMBER_OF_PUBLIC_REPORTSNumber of user-defined public shared reports for this report region
APEX_APPLICATION_PAGE_IRREGION_NAMEName of the interactive report region
APEX_APPLICATION_PAGE_IRSAVE_PUBLIC_AUTH_SCHEMEThis authorization scheme must evaluate to TRUE in order for Public option to display in Save Report dialog
APEX_APPLICATION_PAGE_IRSAVE_PUBLIC_AUTH_SCHEME_IDForeign Key
APEX_APPLICATION_PAGE_IRSHOW_GROUP_BYDetermines whether to show the Group By option in the Actions Menu
APEX_APPLICATION_PAGE_IRSHOW_NOTIFYDetermines whether to show the Notify option in the Actions Menu
APEX_APPLICATION_PAGE_IRSHOW_REPORTS_SELECT_LISTDetermines whether saved reports are displayed as select list in the Search Bar.
APEX_APPLICATION_PAGE_IRSHOW_ROWS_PER_PAGEDetermines whether to show the Rows Per Page option in the Actions Menu
APEX_APPLICATION_PAGE_IRSHOW_SAVE_PUBLICDetermines whether to show the Public option in the Save Report dialog
APEX_APPLICATION_PAGE_IR_COLALLOW_GROUP_BYDetermines whether to allow group by for this column.
APEX_APPLICATION_PAGE_IR_COLALLOW_HIDEDetermines whether to allow hiding this column.
APEX_APPLICATION_PAGE_IR_COLALLOW_HIGHLIGHTINGDetermines whether to allow highlighting for this column.
APEX_APPLICATION_PAGE_IR_COLCOLUMN_EXPRAttribute for internal use only
APEX_APPLICATION_PAGE_IR_COLCOMPONENT_COMMENTDeveloper Comment
APEX_APPLICATION_PAGE_IR_COLNAMED_LOVIdentifies the Shared List of Values to be used to display and filter this report column
APEX_APPLICATION_PAGE_IR_COLREGION_IDID of the interactive report region
APEX_APPLICATION_PAGE_IR_COLTZ_DEPENDENTColumn is time zone dependent
APEX_APPLICATION_PAGE_IR_CONDCONDITION_ALLOW_DELETEIdentifies whether this condition can be deleted
APEX_APPLICATION_PAGE_IR_CONDCONDITION_EXPR_TYPEIf expression is date/time, expression type is Value
APEX_APPLICATION_PAGE_IR_CONDTIME_ZONETime zone of user's database session when condition was saved
APEX_APPLICATION_PAGE_IR_RPTCOUNT_DISTNT_COL_ON_BREAKIdentifies which columns to aggregate with a count distinct
APEX_APPLICATION_PAGE_IR_RPTREPORT_ALIASAn alternate alphanumeric report identifier to use in report link
APEX_APPLICATION_PAGE_IR_RPTREPORT_LINK_EXAMPLEAn example to link to specific saved reports
APEX_APPLICATION_PAGE_ITEMSAJAX_ITEMS_TO_SUBMITIdentifies the page items which should be submitted when an AJAX call is performed for the page item.
APEX_APPLICATION_PAGE_ITEMSAJAX_OPTIMIZE_REFRESHYes or No, identifies if the AJAX call should be optimized.
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_01Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_02Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_03Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_04Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_05Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_06Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_07Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_08Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_09Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSATTRIBUTE_10Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_ITEMSDISPLAY_AS_CODEInternal code of DISPLAY_AS
APEX_APPLICATION_PAGE_ITEMSESCAPE_ON_HTTP_OUTPUTIf Yes values will be escaped when they are written to the HTTP output.
APEX_APPLICATION_PAGE_ITEMSIS_REQUIREDIf set to Yes, APEX will automatically perform a not null validation during page submit.
APEX_APPLICATION_PAGE_ITEMSLOV_CASCADE_PARENT_ITEMSIdentifies the cascading LOV parent item(s) for the item.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_01The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_02The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_03The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_04The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_05The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_06The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_07The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_08The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_09The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LABEL_10The label is the the text the end user of the application will see for the quick pick.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_LINK_ATTRLink attribute which is added to each quick pick link.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_01The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_02The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_03The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_04The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_05The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_06The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_07The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_08The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_09The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSQUICK_PICK_VALUE_10The value defines the value which is used when the quick pick is clicked.
APEX_APPLICATION_PAGE_ITEMSSHOW_QUICK_PICKSIf set to Yes, the entered quick picks will be displayed below the page item.
APEX_APPLICATION_PAGE_ITEMSSTANDARD_VALIDATIONSIdentifies where APEX will perform the built-in standard validations for the item type.
APEX_APPLICATION_PAGE_PROCATTRIBUTE_01Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_02Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_03Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_04Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_05Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_06Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_07Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_08Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_09Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCATTRIBUTE_10Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_PROCCONDITION_TYPE_CODEInternal code of CONDITION_TYPE
APEX_APPLICATION_PAGE_PROCPROCESS_POINT_CODEInternal code of PROCESS_POINT
APEX_APPLICATION_PAGE_PROCPROCESS_TYPE_CODEInternal code of PROCESS_TYPE
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_01Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_02Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_03Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_04Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_05Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_06Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_07Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_08Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_09Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSATTRIBUTE_10Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_REGIONSDISPLAY_REGION_SELECTOR
APEX_APPLICATION_PAGE_REGIONSLIST_IDAssociated list, if region is of type list. Can be joined to APEX_APPLICATION_LISTS.
APEX_APPLICATION_PAGE_REGIONSPARENT_REGION_IDIdentifies the region id of the parent region
APEX_APPLICATION_PAGE_REGIONSPARENT_REGION_NAMEIdentifies the parent region
APEX_APPLICATION_PAGE_REGIONSREST_ENABLEDIdentifies whether the region can be accessed via a RESTful call
APEX_APPLICATION_PAGE_REGIONSSOURCE_TYPE_CODEInternal code of SOURCE_TYPE
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_01Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_02Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_03Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_04Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_05Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_06Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_07Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_08Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_09Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSATTRIBUTE_10Dynamic attribute to store additional data
APEX_APPLICATION_PAGE_RPT_COLSDISPLAY_AS_CODEInternal code of DISPLAY_AS
APEX_APPLICATION_PAGE_RPT_COLSIS_REQUIREDIf set to Yes, APEX will automatically perform a not null validation during page submit.
APEX_APPLICATION_PAGE_RPT_COLSSTANDARD_VALIDATIONSIdentifies where APEX will perform the built-in standard validations for the report column type.
APEX_APPLICATION_PAGE_VALALWAYS_EXECUTEIf set to Yes this flag will overwrites the "Execute Validations" flag for buttons and always execute the validation.
APEX_APPLICATION_PAGE_VALASSOCIATED_COLUMNIf applicable, select the column associated with this validation error message.
APEX_APPLICATION_PAGE_VALTABULAR_FORM_REGION_IDIdentifies the region ID of the tabular form region for column validations
APEX_APPLICATION_PAGE_VALWHEN_BUTTON_PRESSED_IDForeign key to button
APEX_APPLICATION_PROCESSESATTRIBUTE_01Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_02Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_03Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_04Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_05Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_06Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_07Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_08Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_09Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESATTRIBUTE_10Dynamic attribute to store additional data
APEX_APPLICATION_PROCESSESPROCESS_TYPE_CODEInternal code of PROCESS_TYPE
APEX_APPLICATION_TEMP_LISTFIRST_LIST_TEMPLATE_CURRENTFirst list template for current entry template. Defaults to list template current.
APEX_APPLICATION_TEMP_LISTFIRST_LIST_TEMPLATE_NONCURRENTFirst list template for non current entry template. Defaults to list template non current.
APEX_APPLICATION_TEMP_LISTFITEM_TEMPLATE_NONCURR_W_CHILDFirst item template for non current entry with child
APEX_APPLICATION_TEMP_LISTF_ITEM_TEMPLATE_CURR_W_CHILDFirst item template for current entry with child
APEX_APPLICATION_TEMP_REGIONSUB_REGION_HEADER_ENTRY_TEMPLHTML that defined the appearance of a single sub region header entry
APEX_APPLICATION_TEMP_REGIONSUB_REGION_HEADER_TEMPLATEHTML that defined the appearance of a sub region header
APEX_APPLICATION_TEMP_REGIONSUB_REGION_TEMPLATEHTML that defined the appearance of a sub region
APEX_APPLICATION_THEMESDEFAULT_IRR_TEMPLATEIdentifies the default template when creating new components of a corresponding type
APEX_APPLICATION_WEB_SERVICESSOAP_VERSIONIdentifies the SOAP version of the service, 1.1 or 1.2
APEX_DEVELOPER_ACTIVITY_LOGOBJECT_NAMEThe name of the affected component (stored at time of action)
APEX_DEVELOPER_AUDIT_LOGOBJECT_NAMEThe name of the affected component (stored at time of action)
APEX_UI_DEFAULTS_COLUMNSFORM_ATTRIBUTE_01When 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_COLUMNSFORM_ATTRIBUTE_02When 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_COLUMNSFORM_ATTRIBUTE_03When 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_COLUMNSFORM_ATTRIBUTE_04When 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_COLUMNSFORM_ATTRIBUTE_05When 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_COLUMNSFORM_ATTRIBUTE_06When 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_COLUMNSFORM_ATTRIBUTE_07When 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_COLUMNSFORM_ATTRIBUTE_08When 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_COLUMNSFORM_ATTRIBUTE_09When 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_COLUMNSFORM_ATTRIBUTE_10When 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_COLUMNSGROUP_NAMEThe group associated with this column. Will be used for creating regions in forms and groups in interactive reports.
APEX_WORKSPACESALLOW_APP_BUILDING_YNControls availability of identified component
APEX_WORKSPACESALLOW_SQL_WORKSHOP_YNControls availability of identified component
APEX_WORKSPACESALLOW_TEAM_DEVELOPMENT_YNControls availability of identified component
APEX_WORKSPACESALLOW_TO_BE_PURGED_YNControls availability of identified component
APEX_WORKSPACESALLOW_WEBSHEET_DEV_YNControls availability of identified component
APEX_WORKSPACESSOURCE_IDENTIFIERIdentifies the workspace when data is synchronized to other systems.
APEX_WORKSPACE_ACTIVITY_LOGCONTENT_LENGTHThe size of the web page served.
APEX_WORKSPACE_ACTIVITY_LOGINTERACTIVE_REPORT_IDIdentifies the Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR view
APEX_WORKSPACE_ACTIVITY_LOGIR_SAVED_REPORT_IDIdentifies the Saved Interactive Report ID foreign key to the APEX_APPLICATION_PAGE_IR_RPT view
APEX_WORKSPACE_ACTIVITY_LOGIR_SEARCHThe search text entered from Interactive Report search bar
APEX_WORKSPACE_ACTIVITY_LOGWS_APPLICATION_IDWebsheet application primary key, unique over all workspaces
APEX_WORKSPACE_ACTIVITY_LOGWS_DATAGRID_IDID of the Websheet application Data Grid
APEX_WORKSPACE_ACTIVITY_LOGWS_PAGE_IDID of the Websheet application page

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

2 comments:

Peter Raganitsch said...

Nice Job,

it's always good to have a difference when upgrading from one version to another.

Peter

Byte64 said...

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

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles