Skip to main content

Oracle Application Express Views (APEX)


Application Express Views
SELECT * FROM apex_dictionary WHERE column_id = 0;
View Comment Parent View
APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES
APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS
APEX_APPLICATION_AUTH Identifies the available Authentication Schemes defined for an Application APEX_APPLICATIONS
APEX_APPLICATION_AUTHORIZATION Identifies Authorization Schemes which can be applied at the application, page or component level APEX_APPLICATIONS
APEX_APPLICATION_BC_ENTRIES Identifies Breadcrumb Entries which map to a Page and identify a pages parent APEX_APPLICATIONS
APEX_APPLICATION_BREADCRUMBS Identifies the definition of a collection of Breadcrumb Entries which are used to identify a page Hierarchy APEX_APPLICATIONS
APEX_APPLICATION_BUILD_OPTIONS Identifies Build Options available to an application APEX_APPLICATIONS
APEX_APPLICATION_CACHING Applications defined in the current workspace or database user. APEX_APPLICATIONS
APEX_APPLICATION_COMPUTATIONS Identifies Application Computations which can run for every page or on login APEX_APPLICATIONS
APEX_APPLICATION_GROUPS Application Groups defined per workspace. Applications can be associated with an application group. APEX_APPLICATIONS
APEX_APPLICATION_ITEMS Identifies Application Items used to maintain session state that are not associated with a page APEX_APPLICATIONS
APEX_APPLICATION_LISTS Identifies a named collection of Application List Entries which can be included on any page using a region of type List. Display attributes are controlled using a List Template. APEX_APPLICATIONS
APEX_APPLICATION_LIST_ENTRIES Identifies the List Entries which define a List. List Entries can be hierarchical or flat. APEX_APPLICATION_LISTS
APEX_APPLICATION_LOCKED_PAGES Locked pages of an application APEX_APPLICATIONS
APEX_APPLICATION_LOVS Identifies a shared list of values that can be referenced by a Page Item or Report Column APEX_APPLICATIONS
APEX_APPLICATION_LOV_ENTRIES Identifies the List of Values Entries which comprise a shared List of Values APEX_APPLICATION_LOVS
APEX_APPLICATION_NAV_BAR Identifies navigation bar entries displayed on pages that use a Page Template that include a #NAVIGATION_BAR# substitution string APEX_APPLICATIONS
APEX_APPLICATION_PAGES A Page definition is the basic building block of page. Page components including regions, items, buttons, computations, branches, validations, and processes further define the definition of a page. APEX_APPLICATIONS
APEX_APPLICATION_PAGE_BRANCHES Identifies branch processing associated with a page. A branch is a directive to navigate to a page or URL which is run at the conclusion of page accept processing. APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_BUTTONS Identifies buttons associated with a Page and Region APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_CHARTS Identifies a chart associated with a Page and Region. APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_CHART_A Identifies a chart axis associated with a chart on a Page and Region. APEX_APPLICATION_PAGE_CHARTS
APEX_APPLICATION_PAGE_CHART_S Identifies a chart series associated with a chart on a Page and Region. APEX_APPLICATION_PAGE_CHARTS
APEX_APPLICATION_PAGE_COMP Identifies the computation of Item Session State APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_DA Identifies Dynamic Actions associated with a Page APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_DA_ACTS Identifies the Actions of a Dynamic Action associated with a Page APEX_APPLICATION_PAGE_DA
APEX_APPLICATION_PAGE_DB_ITEMS Identifies Page Items which are associated with Database Table Columns. This view represents a subset of the items in the APEX_APPLICATION_PAGE_ITEMS view. APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_FLASH5 Identifies a Flash chart 5 chart associated with a Page and Region APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_FLASH5_S Identifies the Flash chart series which comprise a Flash chart APEX_APPLICATION_PAGE_FLASH5
APEX_APPLICATION_PAGE_GROUPS Identifies page groups APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_IR Identifies attributes of an interactive report APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_IR_CAT Report column category definitions for interactive report columns APEX_APPLICATION_PAGE_IR
APEX_APPLICATION_PAGE_IR_CGRPS Column group definitions for interactive report columns APEX_APPLICATION_PAGE_IR
APEX_APPLICATION_PAGE_IR_COL Report column definitions for interactive report columns APEX_APPLICATION_PAGE_IR
APEX_APPLICATION_PAGE_IR_COMP Identifies computations defined in user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_IR_COND Identifies filters and highlights defined in user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_IR_GRPBY Identifies group by view defined in user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_IR_PIVOT Identifies pivot view defined in user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_IR_PVAGG Identifies aggregates defined for a pivot view in user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_IR_PVSRT Identifies sorts defined for a pivot view in user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_IR_RPT Identifies user-level report settings for an interactive report APEX_APPLICATION_PAGE_IR
APEX_APPLICATION_PAGE_IR_SUB Identifies subscriptions scheduled in saved reports for an interactive report APEX_APPLICATION_PAGE_IR_RPT
APEX_APPLICATION_PAGE_ITEMS Identifies Page Items which are used to render HTML form content. Items automatically maintain session state which can be accessed using bind variables or substitution stings. APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_MAP Identifies the full breadcrumb path for each page with a breadcrumb entry APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_PROC Identifies SQL or PL/SQL processing associated with a page APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_REGIONS Identifies a content container associated with a Page and displayed within a position defined by the Page Template APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_REG_COLS Region column definitions used for regions APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_RPT Printing attributes for regions that are reports APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_RPT_COLS Report column definitions used for report regions APEX_APPLICATION_PAGE_RPT
APEX_APPLICATION_PAGE_TREES Identifies a tree control which can be referenced and displayed by creating a region with a source of this tree APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_VAL Identifies Validations associated with an Application Page APEX_APPLICATION_PAGES
APEX_APPLICATION_PARENT_TABS Identifies a collection of tabs called a Tab Set. Each tab is part of a tab set and can be current for one or more pages. Each tab can also have a corresponding Parent Tab if two levels of Tabs are defined. APEX_APPLICATIONS
APEX_APPLICATION_PROCESSES Identifies Application Processes which can run for every page, on login or upon demand APEX_APPLICATIONS
APEX_APPLICATION_SETTINGS Identifies application settings typically used by applications to manage configuration parameter names and values APEX_APPLICATIONS
APEX_APPLICATION_SHORTCUTS Identifies Application Shortcuts which can be referenced "MY_SHORTCUT" syntax APEX_APPLICATIONS
APEX_APPLICATION_STATIC_FILES Stores the files like CSS, images, javascript files, ... of an application. APEX_APPLICATIONS
APEX_APPLICATION_SUBSTITUTIONS Application level definitions of substitution strings. APEX_APPLICATIONS
APEX_APPLICATION_SUPP_OBJECTS Identifies the Supporting Object installation messages APEX_APPLICATIONS
APEX_APPLICATION_SUPP_OBJ_BOPT Identifies the Application Build Options that will be exposed to the Supporting Object installation APEX_APPLICATION_SUPP_OBJECTS
APEX_APPLICATION_SUPP_OBJ_CHCK Identifies the Supporting Object pre-installation checks to ensure the database is compatible with the objects to be installed APEX_APPLICATION_SUPP_OBJECTS
APEX_APPLICATION_SUPP_OBJ_SCR Identifies the Supporting Object installation SQL Scripts APEX_APPLICATION_SUPP_OBJECTS
APEX_APPLICATION_TABS Identifies a set of tabs collected into tab sets which are associated with a Standard Tab Entry APEX_APPLICATIONS
APEX_APPLICATION_TEMPLATES Identifies reference counts for templates of all types APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_BC Identifies the HTML template markup used to render a Breadcrumb APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_BUTTON Identifies the HTML template markup used to display a Button APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_CALENDAR Identifies the HTML template markup used to display a Calendar APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_LABEL Identifies a Page Item Label HTML template display attributes APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_LIST Identifies HTML template markup used to render a List with List Elements APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_PAGE The Page Template which identifies the HTML used to organized and render a page content APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_POPUPLOV Identifies the HTML template markup and some functionality of all Popup List of Values controls for this application APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_REGION Identifies a regions HTML template display attributes APEX_APPLICATION_THEMES
APEX_APPLICATION_TEMP_REPORT Identifies the HTML template markup used to render a Report Headings and Rows APEX_APPLICATION_THEMES
APEX_APPLICATION_THEMES Identifies a named collection of Templates APEX_APPLICATIONS
APEX_APPLICATION_THEME_FILES Stores the files like CSS, images, javascript files, ... of a theme. APEX_APPLICATION_THEMES
APEX_APPLICATION_THEME_STYLES The Theme Style identifies the CSS file URLs which should be used for a theme APEX_APPLICATION_THEMES
APEX_APPLICATION_TRANSLATIONS Identifies message primary language text and translated text APEX_APPLICATIONS
APEX_APPLICATION_TRANS_DYNAMIC Application dynamic translations. These are created in the Translation section of Shared Components, and referenced at runtime via the function APEX_LANG.LANG. APEX_APPLICATIONS
APEX_APPLICATION_TRANS_MAP Application Groups defined per workspace. Applications can be associated with an application group. APEX_APPLICATIONS
APEX_APPLICATION_TRANS_REPOS Repository of translation strings. These are populated from the translation seeding process. APEX_APPLICATIONS
APEX_APPLICATION_TREES Identifies a tree control which can be referenced and displayed by creating a region with a source of this tree APEX_APPLICATIONS
APEX_APPLICATION_WEB_SERVICES Web Services referenceable from this Application APEX_APPLICATIONS
APEX_APPL_ACL_ROLES Identifies Application Roles, which are workspace groups that are tied to a specific application APEX_APPLICATIONS
APEX_APPL_ACL_USERS Identifies Application Users used to map application users to application roles APEX_APPLICATIONS
APEX_APPL_ACL_USER_ROLES Identifies Application Users used to map application users to application roles APEX_APPL_ACL_USERS
APEX_APPL_CONCATENATED_FILES Concatenated files of a user interface APEX_APPLICATIONS
APEX_APPL_DATA_PROFILES Available Data Profiles used for parsing JSON, XML and other data APEX_APPLICATIONS
APEX_APPL_DATA_PROFILE_COLS Data Profile columns used for parsing JSON, XML and other data APEX_APPLICATIONS
APEX_APPL_DEVELOPER_COMMENTS Developer comments of an application APEX_APPLICATIONS
APEX_APPL_LOAD_TABLES Identifies a named collection of Application Data loding tables which are used to store the metadata information of the data loading tables APEX_APPLICATIONS
APEX_APPL_LOAD_TABLE_LOOKUPS Identifies a the collection of key lookups of the data loading tables APEX_APPLICATIONS
APEX_APPL_LOAD_TABLE_RULES Identifies a collection of transformation rules that are to be used on the load tables. APEX_APPLICATIONS
APEX_APPL_PAGE_CALENDARS Identifies Application Calendars APEX_APPLICATION_PAGES
APEX_APPL_PAGE_IGS Interactive grid definitions APEX_APPLICATION_PAGE_REGIONS
APEX_APPL_PAGE_IG_COLUMNS Interactive grid column definitions APEX_APPL_PAGE_IGS
APEX_APPL_PAGE_IG_COL_GROUPS Interactive grid column group definitions APEX_APPL_PAGE_IGS
APEX_APPL_PAGE_IG_RPTS Interactive grid report definitions APEX_APPL_PAGE_IGS
APEX_APPL_PAGE_IG_RPT_AGGS Interactive grid report aggregate definitions APEX_APPL_PAGE_IG_RPT_VIEWS
APEX_APPL_PAGE_IG_RPT_CHT_COLS Interactive grid report chart column definitions APEX_APPL_PAGE_IG_RPT_VIEWS
APEX_APPL_PAGE_IG_RPT_COLUMNS Interactive grid report column definitions APEX_APPL_PAGE_IG_RPT_VIEWS
APEX_APPL_PAGE_IG_RPT_COMPUTES Interactive grid report computed column definitions APEX_APPL_PAGE_IG_RPTS
APEX_APPL_PAGE_IG_RPT_FILTERS Interactive grid report filter definitions APEX_APPL_PAGE_IG_RPTS
APEX_APPL_PAGE_IG_RPT_HIGHLTS Interactive grid report highlight definitions APEX_APPL_PAGE_IG_RPT_VIEWS
APEX_APPL_PAGE_IG_RPT_VIEWS Interactive grid report view definitions APEX_APPL_PAGE_IG_RPTS
APEX_APPL_PLUGINS Stores the meta data for the plug-ins of an application. APEX_APPLICATIONS
APEX_APPL_PLUGIN_ATTRIBUTES Stores the meta data for the dynamic attributes of a plug-in. APEX_APPL_PLUGINS
APEX_APPL_PLUGIN_ATTR_VALUES Stores the possible values of a plug-in attribute if it's of type selectlist. APEX_APPL_PLUGIN_ATTRIBUTES
APEX_APPL_PLUGIN_EVENTS Stores which events can be triggered by this plug-in. This events are used for binding dynamic actions. APEX_APPL_PLUGINS
APEX_APPL_PLUGIN_FILES Stores the files like CSS, images, javascript files, ... of a plug-in. APEX_APPL_PLUGINS
APEX_APPL_PLUGIN_SETTINGS Stores the values of custom attribute of scope "application" of a plug-in. APEX_APPLICATIONS
APEX_APPL_PLUGIN_STD_ATTRS Stores additional meta data for plug-in standard attributes. APEX_APPL_PLUGINS
APEX_APPL_TEMPLATE_OPTIONS The Template Options identify available CSS classes for pages, regions, report, breadcrumbs, lists, items and buttons APEX_APPLICATION_THEMES
APEX_APPL_TEMPLATE_OPT_GROUPS The Template Option Groups identify groups associated with tempalte options APEX_APPLICATION_THEMES
APEX_APPL_TEMP_PAGE_DP The Page Template Display Points identify the available display points in a page template APEX_APPLICATION_TEMP_PAGE
APEX_APPL_TEMP_REGION_DP The Region Template Display Points identify the available display points in a region template APEX_APPLICATION_TEMP_REGION
APEX_APPL_THEME_DISPLAY_POINTS The Theme Display Points identify the available display points in page and region templates APEX_APPLICATION_THEMES
APEX_APPL_USER_INTERFACES User interfaces of an application APEX_APPLICATIONS
APEX_APPL_WEB_SRC_COMP_PARAMS Web source parameter values for individual APEX components APEX_APPL_WEB_SRC_PARAMETERS
APEX_APPL_WEB_SRC_MODULES Available Web Source Modules within an application APEX_APPLICATIONS
APEX_APPL_WEB_SRC_OPERATIONS Available Web Source Operations APEX_APPL_WEB_SRC_MODULES
APEX_APPL_WEB_SRC_PARAMETERS Input and Output parameters for Web Source Operations APEX_APPL_WEB_SRC_OPERATIONS
APEX_REST_RESOURCE_HANDLERS RESTful services resource handler APEX_WORKSPACES
APEX_REST_RESOURCE_MODULES RESTful services modules APEX_WORKSPACES
APEX_REST_RESOURCE_PARAMETERS RESTful services resource parameters APEX_WORKSPACES
APEX_REST_RESOURCE_TEMPLATES RESTful services resource templates APEX_WORKSPACES
APEX_TEAM_BUGS Identifies bugs, also known as software defects. APEX_WORKSPACES
APEX_TEAM_FEATURES Items that need to get done - i.e. to dos. APEX_WORKSPACES
APEX_TEAM_FEEDBACK Identifies user feedback. APEX_WORKSPACES
APEX_TEAM_FEEDBACK_FOLLOWUP Identifies user feedback followup. APEX_TEAM_FEEDBACK
APEX_TEAM_MILESTONES Identifies bugs, also known as software defects. APEX_WORKSPACES
APEX_TEAM_TODOS Items that need to get done - i.e. to dos. APEX_WORKSPACES
APEX_THEMES List of APEX built-in, public and workspace themes -
APEX_UI_DEFAULTS_ATTR_DICT The Attribute Dictionary is specific to a workspace. It is part of User Interface Defaults and can be used in report and form creation. -
APEX_UI_DEFAULTS_COLUMNS The User Interface Defaults for the columns within this schema. -
APEX_UI_DEFAULTS_GROUPS The User Interface Defaults for the groups within the tables in this schema. Used by the wizards when generating applications. -
APEX_UI_DEFAULTS_LOV_DATA If you create a form, report, or tabular form that includes this column and if the appropriate Display As Type is set to use a list of values (Radio Group or Select List) then a Named List of Values will be created within the application and will be referenced by the resulting item or report column. -
APEX_UI_DEFAULTS_TABLES The User Interface Defaults for the tables within this schema. Used by the wizards when generating applications. -
APEX_WORKSPACES Available Application Express (APEX) workspaces -
APEX_WORKSPACE_ACCESS_LOG One row is logged for each login attempt. APEX_WORKSPACES
APEX_WORKSPACE_ACTIVITY_LOG Page view activity log detail. One row is logged for each page view for application with logging enabled. APEX_WORKSPACES
APEX_WORKSPACE_APEX_USERS Application Express (APEX) workspace users APEX_WORKSPACES
APEX_WORKSPACE_CLICKS Clicks in Application Express that are tracked by using APEX_UTIL.COUNT_CLICKS APEX_WORKSPACES
APEX_WORKSPACE_CREDENTIALS Identifies the credentials within a workspace APEX_WORKSPACES
APEX_WORKSPACE_DEVELOPERS Application Express (APEX) workspace developers, APEX users with privilege to develop applications APEX_WORKSPACES
APEX_WORKSPACE_FILES Identifies uploaded files belonging to the workspace in the modplsql or EPG documents table APEX_WORKSPACES
APEX_WORKSPACE_GROUPS Application Express (APEX) workspace groups/application roles APEX_WORKSPACES
APEX_WORKSPACE_GROUP_GROUPS Application Express (APEX) workspace group/application role to group/role relationship APEX_WORKSPACES
APEX_WORKSPACE_GROUP_USERS Application Express (APEX) workspace users and groups relationship APEX_WORKSPACES
APEX_WORKSPACE_LOG_ARCHIVE Page view activity is a daily summary of workspace acitivity that is retained until physically purged APEX_WORKSPACE_ACTIVITY_LOG
APEX_WORKSPACE_LOG_SUMMARY Page view activity log summarized by application for the last 14 days APEX_WORKSPACE_ACTIVITY_LOG
APEX_WORKSPACE_LOG_SUMMARY_USR Page view activity log summarized by user for the last two weeks APEX_WORKSPACE_ACTIVITY_LOG
APEX_WORKSPACE_REMOTE_SERVERS Remote servers configured within an application APEX_WORKSPACES
APEX_WORKSPACE_RESTENABLED_SQL Remote servers configured within an application APEX_WORKSPACES
APEX_WORKSPACE_SCHEMAS Database Schemas mapped to APEX workspaces APEX_WORKSPACES
APEX_WORKSPACE_SESSIONS Application Express (APEX) sessions by workspace and APEX user APEX_WORKSPACES
APEX_WORKSPACE_SESSION_GROUPS Application Express (APEX) groups that are dynamically assigned to sessions APEX_WORKSPACES
APEX_WORKSPACE_SQL_SCRIPTS Identifies SQL Scripts used to execute SQL and PL/SQL commands APEX_WORKSPACES
APEX_WORKSPACE_STATIC_FILES Stores the files like CSS, images, javascript files, ... of a workspace. APEX_WORKSPACES
APEX_WORKSPACE_UI_TYPES The UI Types identify the available user interface types of a workspace APEX_WORKSPACES
APEX_WS_APPLICATIONS Websheet applications APEX_WORKSPACES
APEX_WS_APP_PAGES Websheet application pages APEX_WS_APPLICATIONS
APEX_WS_DATA_GRID Websheet Data Grid definition APEX_WS_APPLICATIONS
APEX_WS_DATA_GRID_COL Report column definitions for Websheet Data Grid columns APEX_WS_DATA_GRID

Comments

Popular posts from this blog

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Friendly URL: Redirect to Different Page after Login in Oracle APEX 20.1

Oracle has updated apex.oracle.com to APEX 20.1 which includes among other features the new Friendly URL option. Here i am giving an example to redirect to different page after login in Oracle APEX 20.1 [Friendly URL Enabled] Step 1: Define home page for each user in emp master table as below Step 2: To enable Friendly URL Syntax, follow below steps, 1) On the Workspace home page, click the App Builder icon. 2) Select an application (The Application home page appears). 3) From Application home page, you can access the Definition page in TWO ways: Click the Edit Application Properties button. From Shared Components:              1) Click Shared Components .              2) Under Application Logic, click Application Definition Attributes . The Definition page appears. 4) Under Properties, configure the Friendly URL s attribute: Click Apply Changes to save your ch...

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  ...