Fri. Apr 23rd, 2021

Requirement: I have a page build in Oracle APEX. In that page I want to have two tables: Employees Table, and Departments Table. Each of these tables I want to put inside a Tab, that is Employees Table will be in one Tab, and the Departments Table will be in the other Tab. And by default, the Tab which contains the Employees Table will be open by default. The screen show of the above requirement is as below.

Default Screen will look as below:

When we click on the Departments Tab, the screen will look as below:

Solution: For solution of the above requirement follow the steps as shown below:

Step 1: Create a Blank Page in Oracle APEX.

Step 2: Create a Region in the page created in Step 1. Set the Title of the Region as Tabs in Page. Change the Template of the Region as Tabs Container.

Step 3: Create two Sub-Regions inside the Region created in Step 2. Set the Title of the first Sub-Region as Employees Tab, and the second Sub-Region as Departments Tab.

Change the Type of each of these Sub-Regions as Interactive Report.

Now for the Employees Tab set the Source Type as Table/View and the Table Name as EMP. Here EMP table should exist, if not then please create the EMP table.

Similarly, for the Departments Tab set the Source Type as Table/View and the Table Name as DEPT. Here DEPT table should exist, if not then please create the DEPT table.

Step 4: Save and Run the application. Thus, the ran application will look as below:

When we click on the Departments Tab, the screen will look as below:

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 789 total views,  2 views today

By Susanto Paul

Susanto is an Oracle ACE, a qualified MCA, MBA, and a highly-skilled Senior Oracle Specialist. He is an enthusiastic Blogger and YouTuber who helps learners to solve their complex problems more efficiently. He has 9+ years of experience in multiple technologies like AWS, Oracle ADF, Oracle APEX, Oracle JET, Oracle VBCS, Oracle IDCS, Oracle PL/SQL, Oracle Integration Cloud, Java, JDBC, Servlets, JSP, Spring, Hibernate, HTML5, CSS3, JavaScript, TypeScript, NodesJS, Angular, MySQL, Oracle WebLogic Server, JUnit, JMeter, Selenium Web Driver, etc. He is a certified: Oracle Certified Professional Java SE 6 Programmer, Oracle ADF 11g Certified Implementation Specialist, Oracle Cloud Platform Application Integration 2020 Certified Specialist, Oracle Cloud Infrastructure Foundations 2020 Certified Associate, and Oracle Cloud Infrastructure Developer 2020 Certified Associate

Leave a Reply

Your email address will not be published. Required fields are marked *