DBA Hub

📋Steps in this guide1/3

APEX Tips : Include the Database Name in the Application Title

This post shows how to use an application item, substitution variable and application computation to display the database name in the title of an Oracle Application Express (APEX) application.

oracle miscconfigurationintermediate
by OracleDba
12 views
1

Create Application Item

Create an application item to hold the value. - Shared Components > Application Items - Click the "Create" button. - Set the following: Name : DB_NAME Scope : Application Session State Protection : Unrestricted - Name : DB_NAME - Scope : Application - Session State Protection : Unrestricted - Click the "Create Application Item" button.
2

Add Application Item into Title

Next we need to add the application item into the title as a substitution variable. - Shared Components > User Interface Attributes - Edit the "Logo" field to include the application item as a substitution variable. "My Application Name (&DB_NAME.)" - Click the "Apply Changes" button.
3

Populate Application Item

Create an application computation to set the application item value at the start of a new session. - Shared Components > Application Computations - Click the "Create" button. - Set the following: Computation Item : DB_NAME Computation Point : On New Instance (new session) Computation Type : PL/SQL Expression Computation : UPPER(SYS_CONTEXT('USERENV','DB_NAME')) Click the "Create Computation" button. - Computation Item : DB_NAME - Computation Point : On New Instance (new session) - Computation Type : PL/SQL Expression - Computation : UPPER(SYS_CONTEXT('USERENV','DB_NAME')) - Click the "Create Computation" button. The database name should now appear in the application title. Remember, you will have to log out and back in again for the value to be set. For more information see: - APEX Articles Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!