Overview
In Oracle APEX , the navigation bar is a component that allows users to navigate through different pages or components within an application. The navigation bar provides a user interface for easy access to various sections, features, or pages of the application. It typically appears at the top of the application’s interface, and its structure can be customized based on the needs of the application.
Technologies and Tools Used
The following technology has been used to achieve the expected output.
- PL/SQL
- Oracle Apex
Use Case
Customize Display Names: Utilize the capability of Oracle APEX to customize the display names in the navigation bar.
Architecture
Following steps explains in detail,
Following table used for this process.
Step 1:
In the Application, Click on Shared Components in Application Item, Create an Application Item.
Step 2:
In Login page create one Process under Process with PL/SQL Code source.
To store User name into Application page item(Get_user_name)
Paste the following code into PL/SQL Code source area
SELECT USER_NAME INTO :GET_USER_NAME
FROM AUTH_TABLE
WHERE USER_ID=:P9999_USERNAME;
Step 3:
Now save and run the Application with User_id and Password the User_name will be in the session_state And Copy the Item Name
Step 4:
In Shared Component > navigation bar list
Select Navigation Bar and paste the Application page item under name column.
Screen Shot
Output:
Finally Sign out and login with user_id and password, And Successfully username will show in the Top Navigation.
Before the Process:
After the Process:
