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:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community for developers and ask your question. It is FREE.

Vinish Kapoor


Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Inline Feedbacks
View all comments