Press "Enter" to skip to content

Display a Value From Another Table on Page Load in Oracle Apex

In this tutorial, I am giving an example to display a value from another table on page load in Oracle Apex using the Process.

Suppose you have a form based on Employee information and there is a field Department Number which refers to DEPT table. You require to display the department name from DEPT table whenever a form is opened in EDIT mode. To perform this task, follow these steps:

Oracle Apex Process Example – Display a Value from Another Table on Page Load

Step-1: Create a page item next to Department number item and set the type of the item as Display Only.

Step-2: Create a process in before header section and set the following properties as shown in the below image:

Oracle Apex process example.

Enter the following PL/SQL code in the above PL/SQL code section:

v_dname dept.dname%type;
  select dname into v_dname
    from dept where deptno = :p3_deptno;
    apex_util.set_session_state('P3_DNAME', v_dname);
      when others then

Now when you will open the form, it will display the department name value as shown in the below image:

Oracle Apex - display value from another table example

See also:

Vinish Kapoor is created, written, and maintained by Vinish Kapoor. It is built on WordPress, and hosted by Bluehost. Connect with Vinish on Facebook, Twitter, and GitHub.

You may also like: