Oracle APEX Techniques
3.3 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
209 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle APEX Techniques to your Wishlist.

Add to Wishlist

Oracle APEX Techniques

Go beyond the basics and explore how to make the most of the Oracle Application Express environment
3.3 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
209 students enrolled
Created by Packt Publishing
Last updated 1/2015
Curiosity Sale
Current price: $10 Original price: $85 Discount: 88% off
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create your workspace, application, and first page - then find your way around the development environment
  • Enhance the look and feel of your application using themes and templates
  • Add value to your application by extending APEX with JavaScript, visual effects, and multi-media
  • Explore some of the customisable reporting options APEX provides
  • Learn how to build pages with Interactive Reports that don't look like reports
  • Learn some useful supplied APIs to save re-inventing the wheel
  • Discover debugging techniques and instrumentation techniques to assist your problem solving
  • Discover some instrumentation methods to help debug any problems that may arise
  • Configure your application security from log-ins, to roles, to browser security
View Curriculum
  • No presumption is made of skill using Oracle Application Express, but it's helpful to have a general understanding of writing Oracle SQL, PL/SQL, and how a web page is constructed.

Oracle Application Express 4.2 is a diverse web application development tool that helps you build and deploy applications with the latest techniques in JavaScript. A great way to learn these techniques is by watching how Oracle APEX can be used as a tool to create a feature-rich application that comes together before your eyes in small, concise sections, which gives you a chance to repeat the process yourself.
APEX provides you with the ability to extend what's provided out of the box. This video series shows you how to do this - from using Dynamic Actions, to adding JavaScript declaratively, to using multiple reporting options, and the supplied API, down to securing your application from attacks.
Starting by creating a workspace, you will construct a basic application, learn techniques to go beyond the basics, and conclude with the knowledge on how to apply this to your own development environment.
You will learn how to create and enhance your own theme template, add JavaScript and visual effects to your application, deploy Dynamic Actions, create and configure an Interactive report, process custom tabular forms, debug an APEX application, and finally expand and secure the development environment, allowing you to enhance your application to a new level in APEX.
Oracle APEX Techniques is a course that doesn't just teach you how to build a simple application, it will provide you with the skills necessary to expand your applications beyond the basics.

Who is the target audience?
  • Experience with JavaScript is not required. This course is aimed at beginner to intermediate developers, providing the foundation for exploring the advanced.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
40 Lectures
Getting Started with Oracle Application Express
5 Lectures 16:45

A workspace is required to commence development in APEX; learn how to create one. Create a workspace in your APEX environment.

Preview 04:23

Creating your first application can seem scary. See how easy it is with the development wizards. Create your first application using a wizard.

Creating Your First Application

Some development tools require a lot of work to create something small. APEX is a RAD tool that allows you to quickly create pages. Create a feature-rich interactive report with an accompanying form.

Creating Your First Pages

We need to let the user find the data quickly. Let's add a search field to the report page. Create an item as the search criteria for your report.

Creating Your First Item on a Page

To first timers, the APEX development environment can be daunting. Discover common tasks that will help you find your way. Learn your way around the APEX environment.

Finding Your Way around APEX
Managing Your Themes and Templates
5 Lectures 15:49

Protect your theme from APEX patches by making a copy of an existing theme in your workspace. Learn how to define your own workspace theme.

Creating Your Own Theme

One size doesn't fit all. Customise templates to suit your needs. Create your own customised region template.

Creating a Custom Template

Websites without pictures are bland. Learn ways to include image content. Enhance your page layout by including images.

Including Images in your Application

The libraries that are provided don't have all the styles. Find out how to add your own CSS. Enhance the look of your page by including your own CSS.

Referencing CSS

There is more than one position on the screen to deliver content. Learn how to use these locations wisely. Become familiar with page templates to control region positions on your page.

Controlling Layout
Extending APEX
5 Lectures 17:27

Improve data quality and expedite data entry by using browser-level JavaScript validation. Learn how to add JavaScript to your application.

Adding JavaScript to Your Application

Don't build boring applications that look the same. Step outside the square and add visual effects to your application using jQuery. Enhance your application's look by using jQuery to define clever UI components.

Adding Visual Effects to Your Application

Loading CSV files into a table is a common request. APEX provides an easy, wizard-driven solution. Use APEX's own extensions to upload delimited content.

Loading Delimited Data

Purely textual content can be boring. Liven up your application by embedding multimedia. Find out how to embed multimedia content within your pages.

Inserting Multimedia to Your Application

Select lists with a larger number of rows can look untidy. Group similar rows using this free item plug-in. Use a plug-in from the community to enhance select lists in your application.

Consume an Item Plug-in
Deploying Dynamic Actions
5 Lectures 15:53

To provide a more interactive experience, sometimes you need to update the data without submitting a page. Use a dynamic action that saves the input on the click of a button. Update the database without submitting the page.

Preview 02:52

Developers often want to emulate the Forms functionality. Learn how to retrieve information based on user input without submitting the page. Define a dynamic action that runs an Ajax request to populate other fields.

Preview 03:49

Data entry can be more effective if fields are conditionally displayed before submitting the page. Dynamic actions will allow you to show/hide fields without having to handcode JavaScript. Hide/Disable/Show fields based on item selections – no JavaScript required.

Preview 04:01

Some search screens could be made very user friendly by changing results displayed after each key press. Use a dynamic action to trigger this refresh event. Configure a report to show records based on the criteria as it's entered.

Preview 02:36

Data quality may be improved by validating the data before page submission. Dynamic actions simplify this process. Add browser-level validation using basic JavaScript.

Preview 02:35
Reporting from APEX
5 Lectures 17:11

It may be unfeasible to display many reports on one page with download links. Find out how to create a hidden report with a download link. Learn how to piece together an APEX URL that launches the CSV download on the click of a button.

Creating a Hidden Report and Linking CSV Downloads to a Button

Classic reports are the workhorse of the APEX environment, but are limited. Interactive reports offer many more options out of the box. Discover the feature-rich components that interactive reports (IR) provide.

Creating an Interactive Report

A flat view of records sometimes isn't enough. Interactive reports allow the user to customize how the output is shown at runtime. See how to customize the view of an interactive report.

Configuring an Interactive Report

Traditional row/column view of classic reports can be boring. See how you can dress an IR to show information more creatively at design time. Configure your IR so it doesn't even look like a standard report.

Understanding an Interactive Report – Detail View

For APEX to interface with BI Publisher, there needs to be development components. Oracle provides this and more with BI Publisher Desktop & APEX queries and layouts. Set up report query and report layout required for BI Publisher.

Reporting using BI Publisher
Using Supplied APEX APIs
5 Lectures 14:30

Data submitted via tabular forms generate PL/SQL arrays. Learn how to process these with PL/SQL. Discover how to process array data from a tabular form.

Processing Custom Tabular Forms

In tabular forms, checkboxes behave differently to other item types. Learn how to preprocess this array in PL/SQL. Learn how to use checkboxes effectively in tabular forms.

Reading a Checkbox Programmatically

Encourage your users to read context-sensitive help by enhancing the help content. Enhance your application by customizing the Help page.


Metrics are important to help measure the success of the application. Learn how to count how often links are clicked. Measure the level of interest within your application by counting clicks.

Counting Clicks with APEX_util.count_click

Workspace management using the browser can be laborious. Create scripts using APIs to help automate the process. Manage your workspace and applications with scripts using supplied APIs.

Managing your Workspace with Supplied APIs
Looking closer at the APEX Environment
5 Lectures 11:27

If you have multiple applications that need to look the same, repeating all the work can be an issue. Use subscriptions to push changes to multiple applications. Save rework amongst applications by using APEX subscriptions.

Setting up Application Subscriptions

Got a bug in your application? Learn how to use debugging options effectively. See how to use the in-line debugging options in APEX.

Debugging an APEX Application

Not all errors are PL/SQL related. Learn how to debug your HTML and JavaScript with browser debugging options. Use browser inspection tools to debug your application.

Debugging using the Browser

Using the browser to manage APEX isn't always an option. See how SQL Developer makes command-line requests with some basic mouse clicks. Use SQL Developer to remotely manage your applications.

Deploying and Managing APEX with SQL Developer

Learn the correct way to define columns for your reports and help prevent users from using inserted data to run malicious code. Learn how to write SQL that is not susceptible to SQL injection attacks by defining a report with a searchable field.

Expanding the Development Environment Section 8: Configuring APEX Security
APEX Security
5 Lectures 14:45

What if you want to configure the log in process to use your existing tables? Learn how to define custom authentication to do this. Define a custom authentication theme and use it to authenticate log ins to your application.

Securing your Application with Custom Authentication

Certain pages in an application may only be accessible to privileged users. Discover how to effectively secure pages using authorization schemes. Create an authorization scheme and secure access to a page based on that theme.

Protecting your Pages with Authorization Schemes

It is easy for the savvy user to modify the URL to access information they shouldn't see. Secure from URL tampering by using session state protection. Stop users from maliciously or accidentally modifying secured items in your application.

Configuring Session State Protection

Users can enter special data in your normal forms to run browser scripts. See how to display this data so it's shown as it was entered, not run as a script. Learn the correct way to define columns for your reports to prevent malicious code (entered as data) from being executed.

Cross-site Scripting

Poorly written queries are susceptible to SQL injection, potentially exposing secure data. See the correct way to write your queries using bind variables. Learn how to write queries that may not be modified by the end user.

Mitigating SQL Injection
About the Instructor
Packt Publishing
3.9 Average rating
7,336 Reviews
52,482 Students
616 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.