0% found this document useful (0 votes)

26 views51 pages

Creating A Simple Database Application in Oracle APEX

Uploaded by

jomel76sinani

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

26 views51 pages

Creating A Simple Database Application in Oracle APEX

Uploaded by

jomel76sinani

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 51

Creating a simple

database application in
Oracle APEX

Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Tutorial: Creating a simple database application in Oracle APEX

Topic Details
Overview In this tutorial, you will create a simple
database application in Oracle APEX
using App Builder.
Key Concepts • Create an Application using the
Application Wizard
• Create additional pages using the
Page Wizard
• Use existing sequences to populate
primary key columns
• Create Lists of Values to populate
foreign key columns.
• Create Master Detail Forms
• Upload an image file to display on a
page in the application
Difficulty Intermediate
Duration Approximately 90 minutes
Notes Students should have completed either:
Database Design and Programming with
SQL or Database Foundations prior to
attempting this tutorial.

Student will require access to an active

APEX account with tables and data
uploaded from the SQL schema script file
(which can be accessed from section 0 of
either database course).

This tutorial was built using APEX 23.2

2
Part 1: Introduction and getting started

This tutorial will demonstrate how to create a database application using the App Builder component of Oracle Application Express
(APEX).
The application created in this tutorial will allow end-users to add, modify and delete data in the existing Jobs, Employees and
Departments tables without the need to run SQL queries.

Step 1: Log on to APEX

Log on to APEX using your Workspace, Username, and Password. See your instructor for this information and the correct URL for
APEX.

Step 2: Accessing Application Builder

In the Home page of APEX, click the App Builder icon.

Step 3: Create a new application

Click the Create icon to create a new application.

3
Click New Application.

Step 4: Name the application

Follow the steps below to continue creating the application:
Name: Employee Database Application
Appearance: Click the set appearance icon

Leave as default Vita theme.

Click on the icon next to the application name.

4
Select an Icon and its color to use for your application, then click Set Application Icon.

Scroll down to the Settings options.

Application ID: Do not change the Application number. APEX creates an application number by default and it is recommended that you
do not change this number.
Schema: your schema workspace will be displayed by default.
Authentication: Oracle APEX Accounts

NOTE: do NOT click Create Application at this time.

5
Step 5: Add a page to the application
A “Home” page is added automatically to your application, this will be the parent page for any other page that we add.
In this step, we will add a page that will display the data in the jobs table.
Scroll up to the Add Page link and click it.

Select Interactive Report.

In Add Report Page, enter the following:

Page Name: Jobs
Table or View: Click the list icon, find the Jobs table and click it.
Click Set Icon and select the icon you want to use for the page.
Click Add Page.

6
The Jobs page should show in your application.

Scroll down and click the Create Application button.

7
You will see your application and the pages it contains. If your pages are displayed as a list, click the view icons button.

Note: Each page has a number in front of it. This is just the order in which they were created. If you delete a page and recreate it will
take a new number. Do not worry if your number does not match these notes.

8
Step 6: Run and test application
Click the Run Application icon. Your application will open in a new browser window (or tab). Login using your APEX user name and
password.

Once the app is displayed in the browser, click the Jobs page from the navigation pane on the left or by clicking the page icon.

The data in the jobs table will be displayed.

Close the browser window (or tab) showing the running application.
Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

9
Part 2: Add an Employees page using the Create Page Wizard

Step 1: Edit the application and start the Page Wizard.

In APEX, you can access your application at any time by clicking the App Builder tab to return to Application Builder home page.

Click the Employee Database Application Icon.

From the application home page, click the “Create Page” button to start the Page Wizard.

10
Step 2: Edit Select Page Type.
Click “Interactive Grid”

Click Interactive Grid

Step 3: Select page properties.

Enter the following properties for the pages:
Page Number: leave as is
Name: Employees Report
Page Mode: Normal
Include Form Page: Selected
Form Page Number: leave as is
Form Page Name: Update Employee
Form Page Mode: Drawer
Data Source: Local Database
Source Type: Table
Table/View Name: EMPLOYEES Report
Use Breadcrumb: Selected
Breadcrumb Parent Entry: Home (Page 1)
Use Navigation: Selected
Navigation Preference: Map to an existing gentry
Parent Navigation Menu Entry: No Parent Selected
Icon: fa-forms
Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

11
Leave other fields as the default selection, and click the “Next” button

12
Step 4: Select Key.
Enter the following properties for the pages
Primary Key Column 1: EMPLOYEE_ID (Number) (if not already selected)
Leave the rest as default.
Click the “Create Page” button.

The Employees Report will open in the Page Designer view. Click the Application Number to return to the application’s home page.
(Note: your application number will be different).

You will see that you new page has been added to your app, Employees . Click the Run Application icon.

13
Login with your APEX username and password if prompted, click “Employees Report” from the Navigation Menu, and you will see all
employees displayed. Click the Edit icon next to an employee id.

The Update Employees Form is displayed, which allows employee details to be edited. Do not attempt to modify or insert records at this
time. Close the Update Employee Form by either clicking one of the pages in the Navigation Menu on the left of the window, or scroll
down the Update Employee Form and click the Cancel Button.

14
Part 3: Include Lists of Values on the Update Employees page.
The employees table has three foreign key columns. In order to successfully insert or update a record, valid values must be used for
these columns that already exist in the parent tables. Using values that are not present in the parent tables will result in an integrity
constraint error when attempting to insert or update a record.
To avoid this happening, we can create Lists of Values (LOVs) that force the user to select only valid values that already exist in the
parent tables.

Step 1: Open the Update Employee page for editing.

From the application home page, Click page 4 – Update Employee.

The page will open in Page Designer view.

Step 2: Edit the department_id item to use a List of Values.

From the Rendering tab, select P4_DEPARTMENT_ID by left mouse clicking it. (If the items are not listed, you may need to expand
Regions, Content Body and Items).

15
In the Page Item area, change the Type to “Popup LOV”, and the Label to “Department Name”. You will see errors highlighted, we will
correct these in the next step.

Step 3: Add SQL statement to populate List of Values.

In the “Page Item” area, scroll down to see the List of Values settings.
For “Type” select SQL Query, and when the SQL Query box is visible, enter the following SQL statement:

SELECT department_name, department_id

FROM departments;

The SELECT clause of the statement selects 2 columns, the first is which value will be displayed in the LOV, and the second which
value will be inserted into the table. In order that the end user does not have to remember the department id for each department, the
LOV will display the name of the department, but when the row is inserted or modified, the corresponding department id will be inserted
into the employee record. Click the “Save” button above the Page Item tab to save your changes.

16
Step 4: Test the SQL statement is adding correct values.
Run the application and from the Employees Report page, click create.

The Update Employees page will open, scroll down to the Department Name field and click the up arrow to the right of the field. A
popup box should display showing the eight department names contained in the departments table. Do not attempt to modify or insert
records at this time.

17
Step 5: Edit the job_id item to use a List of Values.
We will now add another LOV for the job_id field, similar to how we did previously.
Ensure page 4 – Update Employees is open in Page Designer. From the Rendering tab, select P4_JOB_ID by left mouse clicking it. (If
the items are not listed, you may need to expand Regions, Content Body and Items).
In the Page Item area, change the Type to “Popup LOV”, and the Label to “Job Title”. You will see errors highlighted, we will correct
these in the next step.

Step 6: Add SQL statement to populate List of Values.

In the “Page Item” area, scroll down to see the List of Values settings. For “Type” select SQL Query, and when the SQL Query box is
visible, enter the following SQL statement:

SELECT job_title, job_id

FROM jobs;

Click Save, and run the application to test, as you did previously with the LOV for departments.

18
Step 7: Create a shared List of Values.
We will now add another LOV to use for the manager_id field. Later in this Lab, we will create a page to view and modify the
Departments table, which also has a manager_id column. To save duplication of work, we can create the LOV as a Shared Component,
and access it from both pages.

From the Page Designer, click the Shared Components Icon.

From the Other Components section, click List of Values.

Click the Create button.

For Source, select From Scratch, then click Next.

19
For Name and Type, enter Name: get_managers, Type: Dynamic, then click Next.

20
For Source Type, select SQL Query.

The SQL statement for this LOV is a little more complicated than the previous examples we have done. Firstly, we want to display both
the manager first name and last name. As these are two different columns in our table, we need to use the concatenation operator (two
“pipe” symbols || ) to display the manager full name as if it were a single column.
We also need to add a WHERE clause as, only employees with a job id of “AD_PRES”, “AD_VP” or employees with the text “_MAN” or
“_MGR” in their job_id can be managers.
Enter the following code in the Code Editor:

SELECT first_name ||' '|| last_name, employee_id

FROM employees
WHERE job_id IN ('AD_PRES', 'AD_VP')
OR job_id LIKE '%_MAN'
OR job_id LIKE '%_MGR';

Once the statement is entered, click the “Validation icon” (a tick inside a circle), and if you receive a validation successful message,
click Next.
Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

21
Accept the values for Column Mappings, and click Create.

The List of values will be displayed on the Shared Components LOVs page. Click the Application number to return to the application
home page.

22
Step 8: Use the Shared List of Values in the Update Employees page.
From the application home page, click Update employee to open the page in Page Designer.

From the Rendering tab, select P4_MANAGER_ID by left mouse clicking it. (If the items are not listed, you may need to expand
Regions, Content Body and Items).
In the Page Item area, change the Type to “Popup LOV”, and the Label to “Manager Name”. You will see errors highlighted, we will
correct these in the next step.

In the “Page Item” area, scroll down to see the List of Values settings. For “Type” select Shared Component, for List of Values, select
GET_MANAGERS. Click Save.

Run the application to test, as you did previously with the LOV for departments and jobs. If you have coded your SQL statement
correctly, the Popup LOV for Manager Name should show only the seven employees that can be managers. Do not attempt to insert a
new record at this time.

23
Part 4: Use a sequence to manage primary key values on the Update Employees page.
If you tried to insert a new employee on the Update Employee page, you would receive an error message. The employee_id item is
hidden by default, so the user cannot enter a value for the primary key of the table. One solution would be to edit the page and change
the employee_id item’s type from “Hidden” to “Number Field”, and users could then enter a value for the employee_id.
It is however, unrealistic to expect end users to know what value to use for the primary key, especially if the table is large and has many
rows.
We can create a process that will use a sequence, employees_seq (which was created in your schema when you ran the script to
create and populate the tables) to automatically add values for the employee_id column.

Step 1: Create a new process.

Open Page 4 Update Employee in Page designer view as before and click the Processing tab.

Right click on Processes, and select “Create Process”.

24
Step 2: Enter code for the process.
For the Process name, enter get_pk, ensure Type is set to Execute Code, and in the Source area. Check that Location is Local
Database and language is PL/SQL. Click the icon to open the code editor.

Enter the following code in the code Editor:

BEGIN
IF :P4_EMPLOYEE_ID IS NULL
THEN
SELECT employees_seq.NEXTVAL
INTO :P4_employee_id
FROM dual;
END IF;
END;

25
Once the statement is entered, click the “Validation icon” (a tick inside a circle), and if you receive a validation successful message,
click OK.

The new get_pk process must run before the other process to ensure that employee_id has a value before the insert is processed.
In the processes tab, left mouse click and drag the new get_pk process so that it is above the Process form Update Employees
process. Click Save.

Step 3: Run and test.

Run the application to test. Open the Employees Report and click the Create button. Enter values for a new employee and click Create.

You should receive a message that the insert was successful and see the new employee included in the Report page.

26
Part 5: Add a new Page to view departments and their employees.
In this section, we will add a Master Detail Form, which will display departments, and the employees that are assigned to each
department on a separate page. The page will also allow the user to update, add and delete departments.
Master Detail refers to the relationship between the two tables. The employees table has a foreign key relationship with the
departments table, so the departments table is known as the “master” table, and employees as the “detail” table.

Step 1: Run the Page Wizard to create the new Forms.

From the application home page, click the “Create Page” button.

Select Master Detail.

27
Select Drill Down.

For Page Attributes, enter:

Page Number: 5 (if not 5 leave suggested number
Master Page Name: Departments
Table / View Name: Departments
Leave rest as default.
Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

28
Click Next.

Step 2: Apply Master and Detail settings.

For Master Source, ensure location tab is set to Local Database and select the following:
Table: search for the departments table and select
Primary Key column: department_id
Form Navigation order: department_id
Ensure all four columns are shown in the right pane and click next.

29
Step 3: Apply Master and Detail settings for Employees.
Select the following:
Name: Department Employees
Table/ View Name: Select Employees

Create the link between the tables.

Primary Key column1: employee_id

Master Detail Foreign Key department_id -> department_id

30
Step 4: Use LOV for manager id foreign key column.
Ensure Department Employees is open in Page Designer.
From the Rendering tab, select MANAGER_ID by left mouse clicking it. (If the items are not listed, you may need to expand Regions,
Content Body, Form on Departments and items).
In the Page Item area, change the Type to “Popup LOV”, and the Label to “Manager Name”. You will see errors highlighted, we will
correct these in the next step.

In the “Page Item” area, scroll down to see the List of Values settings. For “Type” select Shared Component, for List of Values, select
GET_MANAGER. Click Save.

31
Step 5: Use LOV for location id foreign key column.
Ensure page 6 – Department Employees is open in Page Designer.
From the Rendering tab, select P6_LOCATION_ID by left mouse clicking it. (If the items are not listed, you may need to expand
Regions, Content Body, Form on Departments and items).
In the Page Item area, change the Type to “Popup LOV”, and the Label to “City”. You will see errors highlighted, we will correct these in
the next step.

In the “Page Item” area, scroll down to see the List of Values settings. For “Type” select SQL Query and enter the following code:

SELECT city, location_id

FROM locations;

Click Save.

32
Step 6: Set employee details to be view only.
By default the employees are displayed in an editable interactive grid, which allows users to update employee records. We want users
to manage employee records on the existing Update Employee page. Ensure Page 6 –Department Employees is open in Page
Designer.
From the rendering tab, left click Department Employees to select the form. In the Region tab, change Type from Interactive Grid to
Interactive report. Click Save.
Run your application to test. Do not create a new department at this time.

Part 6: Use a sequence to manage primary key values on the Update Departments page.
In this step, we will create a new process to automatically generate primary key values using an existing sequence when creating a new
department, in the same way we did earlier for the employee_id primary key.

Step 1: Create a new process.

Open Page 6 Department Employees in Page designer view, and click the Processing tab.

33
Right click on Processes, and select “Create Process”.

Step 2: Enter code for the process.

For the Process name, enter get_dept_pk, ensure Type is set to PL/SQL code, and in the Source area, click the icon to open the code
editor.

34
Enter the following code in the code Editor:

BEGIN
IF :P6_DEPARTMENT_ID IS NULL
THEN
SELECT departments_seq.NEXTVAL
INTO :P6_department_id
FROM dual;
END IF;
END;

Once the statement is entered, click the “Validation icon” (a tick inside a circle), and if you receive a validation successful message,
click OK.

The new get_dept_pk process must run before the other process to ensure that department_id has a value before the insert is
processed.
In the processes tab, left mouse click and drag the new get_dept_pk process so that it is above the “Process form Form on
Departments” process.
As we changed the Department Employees to show as an Interactive Report that is not editable, we also need to delete the process to
save the Interactive grid. Right click on the process “Department Employees – Save Interactive Grid Data” and Delete.

Click Save.

35
Step 3: Run and test.
Run the application and click Departments from the Navigation Menu, then Create.

Enter values for a new department, then click Create.

The new department should be displayed in the Department Report, and a Row created message displayed.

36
Part 7: Improve appearance of Home page and Navigation menu.
At the moment, the Employees and Departments Navigation Menu items have the icon assigned by default when the pages were
created. In this section we will update the icons, and add tiles to the home page for these pages also.

Step 1: Change the Navigation Menu icons.

From the application home page, click Shared Components.

In the Navigation and Search section, click Navigation Menu.

37
Click Navigation Menu.

Click Employees Report.

38
For Image/Class, click the list icon.

Scroll down through the icons, and select the fa-user icon.

39
Click Apply changes.

Follow the same process to change the Departments Icon, this time select the icon fa-building. Run the application to test, the new
icons will now be shown in the Navigation Menu.

Step 2: Add navigation tiles to the Home Page.

From the application home page, click Shared Components.

In the Navigation and Search section, click Lists.

40
Click Page Navigation.

41
Click Create Entry

For Image/Class enter fa-user (or browse for the icon using the drop down list). For label, enter Employees Report, and for Page enter
3 or the number you have next to Employees Report.
Click Create and Create Another.

42
For Image/Class enter fa-building (or browse for the icon using the drop down list). For label, enter Departments, and for Page enter 5
or select the one called Departments. Click Create List Entry.

Return to the application home page, and run the application to test. There should now be 3 navigation tiles showing.

43
Part 8: Add an image to the Home page.
First find an image you want to use on the Home Page, and save locally on your PC, noting its location. Make sure the image is not too
large, as we want it to fit on screen without the user having to scroll across the page. The size should be no more than 450 pixels wide,
and 200 pixels high.

Step 1: Upload the image.

From the Application Home Page, click the Shared Components icon.

In the Files and Reports section, click Static Application Files.

44
Click Create File.

Click the Drag and Drop file to browse, locate and select the image you want to use, then click Create.

Your file will be uploaded. Copy the reference into a text document (or take careful note of it) as this is how our application will locate
the file from the home page.

45
Step 2: Add a Region to the Home Page Content Body.
From the application home page, click page 1 – Home.

Select Page Navigation on the left. Locate the Regions tab, and scroll down to see the Static Content Region. Drag the Static Content
Region into the Region Body..

46
The new region will be shown. In the Region tab, enter “Welcome to” as the Title.

Step 3: Add an Image field to the Static Content Region.

Below the Region Body section, click the Items tab, then drag the “Display Image” item to the “ITEMS” area of the Content Body.

47
The Display image should now be shown in the ITEMS area of the Static Image region. In the Page Item area, for Name, enter
P1_IMAGE, and remove the text for Label. For the Settings Based On field, select “Image URL stored in Page Item Value”

In the Page Item area, scroll down until you see the Source section. For Type select Static Value and for “Static Value”, paste the
reference you copied in Step 1. Click Save.

48
Drag Welcome to above P1_IMAGE and select Save.

Step 4: Test the application.

Run the application to test. Your Home page should now look similar to the example below.

You can go back into the home page layout and drag p1_image into the Region Body of Welcome To.

49
Save and reload your application.

If you wanted to have the three blocks under the Oracle Academy then drag Page Navigation and drop it on Welcome To in the Body.

50
This will then create a Sub Region with Page Navigation displayed after the Logo.

Rerun your application.

Creating A Simple Autonomous Database Application in Oracle APEX
No ratings yet
Creating A Simple Autonomous Database Application in Oracle APEX
50 pages
Practice - 03 Creating A Database Application
No ratings yet
Practice - 03 Creating A Database Application
28 pages
Basic Concepts of Oracle Application Express
No ratings yet
Basic Concepts of Oracle Application Express
18 pages
Oracle APEX 19 PDF
100% (3)
Oracle APEX 19 PDF
420 pages
Developing Rich Web Applications With Oracle ADF
No ratings yet
Developing Rich Web Applications With Oracle ADF
196 pages
APEX Report Development Guide
100% (1)
APEX Report Development Guide
34 pages
Apexstudentguide
No ratings yet
Apexstudentguide
866 pages
Implementing A Search Page:: After You Click, You Will See The
No ratings yet
Implementing A Search Page:: After You Click, You Will See The
21 pages
Oracle - Oracle Application Express Workshop I Ed 2: View Online
No ratings yet
Oracle - Oracle Application Express Workshop I Ed 2: View Online
5 pages
APEX Hands-On Labs: Page Controls
No ratings yet
APEX Hands-On Labs: Page Controls
46 pages
Oracle Application Express: Developing Database Web Applications
No ratings yet
Oracle Application Express: Developing Database Web Applications
49 pages
Brad Brown Application Express
No ratings yet
Brad Brown Application Express
41 pages
Oracle ADF Web App Tutorial
No ratings yet
Oracle ADF Web App Tutorial
63 pages
Practice - 19-Migrate Application Development Between Environments
No ratings yet
Practice - 19-Migrate Application Development Between Environments
34 pages
APEX Database App Creation Guide
No ratings yet
APEX Database App Creation Guide
19 pages
Create Database Apps with Oracle APEX
100% (1)
Create Database Apps with Oracle APEX
19 pages
Extending Ebs
100% (1)
Extending Ebs
74 pages
Riaz Ahmed - Oracle APEX 20 For Beginners A Platform To Develop Stunning, Scalable Data-Centric Web Apps Fast (2020) PDF
100% (7)
Riaz Ahmed - Oracle APEX 20 For Beginners A Platform To Develop Stunning, Scalable Data-Centric Web Apps Fast (2020) PDF
419 pages
APEX Wizard Application Report Forms Latest
No ratings yet
APEX Wizard Application Report Forms Latest
45 pages
APEX Forms & Reports Guide
No ratings yet
APEX Forms & Reports Guide
17 pages
Implementing Navigation in Oracle APEX
No ratings yet
Implementing Navigation in Oracle APEX
30 pages
ADFo 1 2 SG
No ratings yet
ADFo 1 2 SG
22 pages
Automatic Search External LOV
No ratings yet
Automatic Search External LOV
29 pages
Oracle Application Express: Developing Database Web Applications
No ratings yet
Oracle Application Express: Developing Database Web Applications
19 pages
HiddenGem PDF
No ratings yet
HiddenGem PDF
182 pages
Oracle APEX Hands-On Lab#2 Building Database Applications
No ratings yet
Oracle APEX Hands-On Lab#2 Building Database Applications
22 pages
Oracle APEX Developer Professional - Activity Guide
67% (3)
Oracle APEX Developer Professional - Activity Guide
454 pages
APEX 5 App Development Guide
No ratings yet
APEX 5 App Development Guide
2 pages
Apex
No ratings yet
Apex
95 pages
Oracle APEX Lab Guide I
No ratings yet
Oracle APEX Lab Guide I
20 pages
Extend EBS Using Applications Express: John Peters
100% (1)
Extend EBS Using Applications Express: John Peters
8 pages
Oracle APEX Developer Training
No ratings yet
Oracle APEX Developer Training
21 pages
Apex101 326750
No ratings yet
Apex101 326750
44 pages
Oracle Application Express: Developing Web Applications: Course Topics
No ratings yet
Oracle Application Express: Developing Web Applications: Course Topics
3 pages
DFo 6 1
No ratings yet
DFo 6 1
17 pages
Oracle APEX Training Guide
No ratings yet
Oracle APEX Training Guide
16 pages
A World of Possibilities Power of Oracle APEX To Extend EBS
No ratings yet
A World of Possibilities Power of Oracle APEX To Extend EBS
75 pages
ADFo 2 1 Practice
No ratings yet
ADFo 2 1 Practice
16 pages
ADFo 2 2 SG
No ratings yet
ADFo 2 2 SG
28 pages
Oracle APEX Course Overview
No ratings yet
Oracle APEX Course Overview
45 pages
Build Web Apps Using APEX & Autonomous Database: Course Topics
No ratings yet
Build Web Apps Using APEX & Autonomous Database: Course Topics
5 pages
DFo 6 1
No ratings yet
DFo 6 1
16 pages
Extend E-Business Suite With Application Express
No ratings yet
Extend E-Business Suite With Application Express
9 pages
Customizing An Interactive Grid As A Developer
No ratings yet
Customizing An Interactive Grid As A Developer
18 pages
Apex Best Practices 134310
No ratings yet
Apex Best Practices 134310
21 pages
Unit 08
No ratings yet
Unit 08
37 pages
Now Combine All The 45 Pages Together and Make The...
No ratings yet
Now Combine All The 45 Pages Together and Make The...
7 pages
Apex-MCQ-9-from-Muhammad Nur E Alam-for-Students
No ratings yet
Apex-MCQ-9-from-Muhammad Nur E Alam-for-Students
14 pages
APEX Security and Development Overview
No ratings yet
APEX Security and Development Overview
14 pages
Oracle App Framework Training Guide
No ratings yet
Oracle App Framework Training Guide
42 pages
APEX Hands-On Lab: Getting Started
No ratings yet
APEX Hands-On Lab: Getting Started
12 pages
Oracle Application Express: Developing Database Web Applications
No ratings yet
Oracle Application Express: Developing Database Web Applications
14 pages
Apex Install On Linux
No ratings yet
Apex Install On Linux
7 pages
Oracle APEX Features & Integration
100% (3)
Oracle APEX Features & Integration
47 pages
Oracle Basic Navigation Student Guide
No ratings yet
Oracle Basic Navigation Student Guide
76 pages
DBMS Cep 6
No ratings yet
DBMS Cep 6
11 pages
Time: 3 Hour Max - Marks: 75: Model Question Paper Diploma in Computer Engineering
No ratings yet
Time: 3 Hour Max - Marks: 75: Model Question Paper Diploma in Computer Engineering
4 pages
Book 2 - Chapter4
No ratings yet
Book 2 - Chapter4
59 pages
Form of Basic SQL Query in DBMS
No ratings yet
Form of Basic SQL Query in DBMS
15 pages
SQL Nanodegree Program Syllabus
No ratings yet
SQL Nanodegree Program Syllabus
10 pages
ch06 2
No ratings yet
ch06 2
52 pages
SQL Commands Basics To Advanced Neat
No ratings yet
SQL Commands Basics To Advanced Neat
3 pages
DBMS SQL Clauses - Javatpoint
No ratings yet
DBMS SQL Clauses - Javatpoint
6 pages
TFORMer E
No ratings yet
TFORMer E
26 pages
Relational Model & SQL Basics
No ratings yet
Relational Model & SQL Basics
74 pages
M5 Glossary
No ratings yet
M5 Glossary
2 pages
Resume Templete1
No ratings yet
Resume Templete1
3 pages
Half Yearly Class12 Answer
No ratings yet
Half Yearly Class12 Answer
9 pages
Course Outline - 20461D
No ratings yet
Course Outline - 20461D
8 pages
Relativity - Configuration Table Guide - 9.2
No ratings yet
Relativity - Configuration Table Guide - 9.2
101 pages
Kiran Academy Software Testing Course
No ratings yet
Kiran Academy Software Testing Course
12 pages
Understanding Primary and Secondary Indexes
No ratings yet
Understanding Primary and Secondary Indexes
29 pages
Slowly Changing Dimensions Concepts
No ratings yet
Slowly Changing Dimensions Concepts
14 pages
Mysql 2. Oracle 3. Microsoft SQL Server
No ratings yet
Mysql 2. Oracle 3. Microsoft SQL Server
11 pages
Essential SQL Clauses for Data Aggregation
No ratings yet
Essential SQL Clauses for Data Aggregation
3 pages
Unit-5 14M
No ratings yet
Unit-5 14M
26 pages
CENG301 DBMS - Session-7
No ratings yet
CENG301 DBMS - Session-7
31 pages
Scribe Insight Tutorial
No ratings yet
Scribe Insight Tutorial
30 pages
DMS Questions and Answers
No ratings yet
DMS Questions and Answers
10 pages
CH 08
No ratings yet
CH 08
33 pages
Database Lab Manual 5 FAST NUCES
No ratings yet
Database Lab Manual 5 FAST NUCES
11 pages
Oracle Interview Q&A Guide PDF
No ratings yet
Oracle Interview Q&A Guide PDF
12 pages
Bus Ticket
No ratings yet
Bus Ticket
62 pages
Database Systems An Application Oriented Approach (Selected Solutions)
100% (1)
Database Systems An Application Oriented Approach (Selected Solutions)
72 pages
SQL Mastery for Job Seekers
No ratings yet
SQL Mastery for Job Seekers
28 pages

Creating A Simple Database Application in Oracle APEX

Uploaded by

Creating A Simple Database Application in Oracle APEX

Uploaded by

Creating a simple

Student will require access to an active

This tutorial was built using APEX 23.2

Step 1: Log on to APEX

Step 2: Accessing Application Builder

Step 3: Create a new application

Step 4: Name the application

Leave as default Vita theme.

Scroll down to the Settings options.

NOTE: do NOT click Create Application at this time.

Select Interactive Report.

In Add Report Page, enter the following:

Scroll down and click the Create Application button.

The data in the jobs table will be displayed.

Step 1: Edit the application and start the Page Wizard.

Click the Employee Database Application Icon.

Click Interactive Grid

Step 3: Select page properties.

Step 1: Open the Update Employee page for editing.

The page will open in Page Designer view.

Step 2: Edit the department_id item to use a List of Values.

Step 3: Add SQL statement to populate List of Values.

SELECT department_name, department_id

Step 6: Add SQL statement to populate List of Values.

SELECT job_title, job_id

From the Page Designer, click the Shared Components Icon.

From the Other Components section, click List of Values.

Click the Create button.

For Source, select From Scratch, then click Next.

SELECT first_name ||' '|| last_name, employee_id

Step 1: Create a new process.

Right click on Processes, and select “Create Process”.

Enter the following code in the code Editor:

Step 3: Run and test.

Step 1: Run the Page Wizard to create the new Forms.

Select Master Detail.

For Page Attributes, enter:

Step 2: Apply Master and Detail settings.

Create the link between the tables.

Primary Key column1: employee_id

SELECT city, location_id

Step 1: Create a new process.

Step 2: Enter code for the process.

Enter values for a new department, then click Create.

Step 1: Change the Navigation Menu icons.

In the Navigation and Search section, click Navigation Menu.

Click Employees Report.

Step 2: Add navigation tiles to the Home Page.

In the Navigation and Search section, click Lists.

Step 1: Upload the image.

In the Files and Reports section, click Static Application Files.

Step 3: Add an Image field to the Static Content Region.

Step 4: Test the application.

Rerun your application.

You might also like