Database Application Based on Existing Tables
Start course

This course will guide you through how to create a database application through a variety of features offered by Oracle APEX.

Learning Objectives

  • Gain a foundational understanding of App Builder Concepts
  • Learn how to access App Builder and how to access the Create Application Wizard to build your APEX applications.
  • Understand how to create an APEX application based on existing tables
  • Understand how to create an Apex application from a file
  • Learn about Progressive Web Applications and how to enable Progressive Web Application installability within your APEX application

Intended Audience

  • Anyone who wants to enhance their knowledge of Oracle APEX


We recommend that you take this course as part of our Oracle APEX: Foundations learning path.


Hello, welcome to Oracle APEX Foundation's Course, Creating a Database Application module, Application based on existing tables lesson. My name is Chaitanya. I'm a product manager on the Oracle APEX Product Development team. So, now you know how to access the Create Application Wizard. So, let's go ahead and learn how to create an application based on existing tables. In this lesson, we'll learn how to create an APEX application based on existing tables. Now, let's take a quick look at the steps involved in creating an application based on existing tables. In the first step, you login to your Oracle APEX workspace and then click 'App Builder', then click 'Create'. Click 'New Application' and then enter your application name. Select an application icon and then click 'Set Appearance' to change the appearance of your application.

Save the changes to your application's appearance. In the next step, click 'Add Page' to add pages to your application. Select the page of your choice, enter/select the details, and repeat this particular step if you want to add multiple pages to your application. Select features to include in your application, review the settings, and then click 'Create Application'. Click 'Run Application' and then finally log in to review your application. Now, let's watch demo that shows these steps involved in creating an application based on existing tables. Creating an APEX application based on existing tables in the database. On your workspace homepage click 'App Builder' and then click 'Create'. We want to create a new application, click 'New Application'. The Create Application Wizard appears. Enter a name to identify the application to developers. For example, in this case, let's enter Employee Details App. And then you want to set an icon for your application, so click 'Set' icon.

Let's also change the colour and then let's pick an icon. For example, let's pick the cloud icon and then click 'Save' icon. For appearance, you can actually accept the default appearance, but you want to change the appearance in this case, so let's click 'Set Appearance' icon and then you see theme styles, Vita, Vita-Dark, and Redwood Light. Let's pick up Redwood Light, accept the defaults for navigation, and then let's save the changes for appearance. In the next step, let's add pages to your application, so click 'Add Page'. The App Page dialog appears. You can now see different page types; Blank Page, Calendar, Cards, Chart, Dashboard, Faceted Search, Smart Filters, Form, Interactive Grid, Interactive Report, Map, and Master Data. You can select a page type of your choice. The user interface changes based on the page tag you select. Pages that you create will be displayed on the homepage.

After you create the application, you can modify the pages and add additional pages using the Create Page Wizard. Now in this example, let's add an interactive report, so select 'Interactive Report'. Enter a name for page name. For example, lets enter Employees Report. For table or view, let's select EMP table, which is already existing in the database. Let us also select the Include Form checkbox, then expand Lookup Columns. For Lookup Key 1, let's select department number. And for Display Column, let's select department name. Now click 'Add Page'. If you want to add additional pages, click 'Add Page'. We now see that the Employees Report, interactive report has been successfully added. Now, scrolling down a bit, you see features that you can select to include with your application.

Features provide application level functionality and can only be added once per application. You can see the features such as Install Progressive Web App, which gives your application the ability to be installed. There is About Page, which adds an about this application page. You also have Access Control, Activity Reporting, Configuration Options, and then Feedback, which allows users to provide feedback. You also have Theme Style Selection feature. Now, in this example, lets select all of the features, so let's click 'Check All'. Scrolling down you see settings. Now, the first one is Application ID, which is a unique numeric identifier for your application.

This field contains an automatically generated identifier by default. Lets accept the default for Application ID, and then you see Schema here, Authentication, Language, Advanced Settings, and User Interface Defaults. Lets accept the default settings as is, and then finally lets click 'Create Application'. You can now see the application creation progress. The application is now successfully created, let's run the application. Enter your workspace username and password, and then click 'Sign In'. You can now see the application homepage, click the left navigation menu, You can see Home, Employees Report, and Administration. Let's click Employees Report, this displays the interactive report page for you. In the interactive report, let's click the pencil icon for any record, and that displays the Employee Form dialog. In this lesson, we learned how to create an APEX application based on your existing database tables. This concludes the lesson on application based on existing tables. I'm sure you find that useful. Thank you for watching.

About the Author
Oracle University
Training Provider
Learning Paths

Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.

Covered Topics