8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
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.
Related articles.
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
- Click the "Create Application Item" button.
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.
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.
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:
Hope this helps. Regards Tim...