MCT495 - Oracle Application Express

Outline info
Last revision date 2018-07-20 11:59:23.193
Last review date 2018-07-20 11:59:33.549

Subject Title
Oracle Application Express

Subject Description
Learn to use a variety of Application Express components and wizards to build applications and database objects that are easy to deploy plus build forms and reports and incorporate different types of items and shared components. (Prepares for Oracle Exam IZI-450).

Credit Status
 This subject is part of the Oracle Application Developer Recognition of Achievement program.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Login to Oracle Application Express.
2. Identify the Components of an Application.
3. Develop a database-centric Web application.
4. Manage database objects.
5. Build queries of database objects and incorporate in an application.
6. Build and Customize Interactive Reports.
7. Create Forms.
8. Utilize and Manage Shared Components in an Application.
9. Add Page Processing Components.
10. Deploy the Application as a Packaged Application.
11. Manage users and groups.
12. Manage Access Control by authorizing and authenticating users.
13. Administer Oracle Application Express Workspaces.
14. Load and Unload data or application components.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

MCT491 or equivalent experience  

Topic Outline

Introducing Oracle Application Express

  • Explaining Oracle Application Express Concepts
  • Identifying the Components of Oracle Application Express
  • Explaining the Oracle Application Express architecture
  • Creating a Workspace and a Workspace administrator user
  • Installing and Running a Sample Application provided with Oracle Application Express
  • Installing a Packaged Application
  • Logging in to an Oracle Application Express Workspace

Interacting with the Database by Using SQL Workshop
  • Browsing, Creating, and Modifying Objects
  • Processing Ad Hoc SQL Statements
  • Managing SQL Scripts
  • Creating, Running, and Saving SQL Queries

Building an Application
  • Identifying the Components of an Application
  • Creating an Application from Scratch
  • Creating an Application from a Spreadsheet

Creating Reports
  • Identifying Report Types
  • Creating Interactive Reports
  • Generating Reports Using Wizards
  • Manipulating your Interactive Report
  • Customizing your Interactive Report

Creating Forms
  • Identifying the types of Forms
  • Creating a Form on a Table with Report
  • Creating a Tabular Form
  • Creating a Master Detail Form
  • Editing Form Attributes

Working with Pages and Regions
  • Viewing Page Definitions
  • Editing Page Attributes
  • Creating a New Region
  • Viewing Region Attributes
  • Adding Comments

Adding Items and Buttons
  • Creating Items
  • Editing Item Attributes
  • Creating Buttons
  • Editing Button Attributes

Understanding Session State and Debugging
  • Implementing Session State
  • Setting a Session State Value
  • Clearing the Session State
  • Reviewing the Session State
  • Reviewing the Messages in Session State

Including Page Processing
  • Explaining the Difference Between Page Rendering and Page Processing
  • Creating Computations for your Application
  • Validating Input Data
  • Process Data
  • Creating Application Branching

Adding Shared Components That Aid Navigation
  • Providing an Overview of Shared Components
  • Managing Parent and Standard Tabs
  • Managing Navigation Bars
  • Managing Lists
  • Managing Breadcrumbs

Adding Other Shared Components
  • Including List of Values in your Application
  • Creating Trees
  • Accessing Shared Component Reports
  • Setting User Interface Defaults

Displaying Dynamic Content
  • Filtering Reports Using Dynamic Queries
  • Creating Charts Using a Wizard
  • Creating a Calendar
Working with Themes and Templates
  • Explaining Themes and Templates
  • Switching to a Different Theme
  • Creating a Custom Theme
  • Viewing Existing Templates
  • Creating and Editing a Template
  • Referencing a Cascading Style Sheet
  • Changing a File to Use a Class in the Referencing style sheet

Administering Oracle Application Express Workspaces
  • Managing Users
  • Requesting a Schema or Storage
  • Purging Session State
  • Monitoring Developer Activity Log
  • Monitoring Workspace Activity
  • Viewing Activity Reports

Implementing Security
  • Differentiating Between Authentication and Authorization
  • Providing an Authentication Scheme
  • Creating an Authorization Scheme Using Access Control
  • Enabling and Configuring Session State Protection

Deploying Your Application
  • Defining Supporting Objects
  • Exporting Your Application
  • Importing Your Application
  • Installing Supporting Objects

Using Utilities
  • Importing and Exporting Data
  • Generating Data Definition Language (DDL) Statements
  • Viewing Object Reports
  • Viewing the Data Dictionary
  • Monitoring the Database

Mode of Instruction
The primary mode of learning is through classroom lecture and instruction and hands on labs. Additional modes of instruction include class discussion, lecture and question and answer period.

Prescribed Texts
The following materials will be provided:
Oracle's ebook 

Required Supplies
USB Flash Drive 

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( or at Seneca's Registrar's Offices.

Modes of Evaluation
This subject is part of the Oracle Application Developer Recognition of Achievement program. Those students choosing to pursue their Oracle Application Developer Recognition of Achievement are required to write a final exam at the completion of this subject. A mark of 70% of higher is required in the exam in order to apply this subject to the Recognition of Achievement. 

Approved by: Denis Gravelle