Oracle APEX Techniques [Video]

Scott Wesley

Oracle APEX Techniques [Video]
Downloadable video: $34.99
save 15%!

Packt Video. Stream online or download for unrestricted offline use. Learn more

Course Contents
The Author
Sample Clip
  • New! Packt Video courses: practical screencast-based tutorials that show you how to get the job done. Bite sized chunks, hands on instructions, and powerful results.
  • Make the most of the extensibility of Oracle APEX 4.2
  • Deploy dynamic actions to make your application more interactive without needing to learn JavaScript
  • Provided with practical examples and solutions to problems you will encounter as you start to push the product to fit your requirements

Video Details

Language : English
Release Date : Thursday, May 30, 2013
Course Length : 120 mins
ISBN : 1849689342
ISBN 13 : 9781849689342
Author(s) : Scott Wesley
Topics and Technologies : All Books, Enterprise Products and Platforms, Video, Enterprise, Oracle

Table of Contents

  1. Getting started with Oracle Application [15:20 minutes]
    • Creating your Workspace
    • Creating your First Application
    • Creating your First Pages
    • Creating your First Item on a Page
    • Finding your Way around APEX

  2. Managing your Themes and Templates [15:33 minutes]
    • Creating your Own Theme
    • Creating a Custom Template
    • Including Images in your Application
    • Referencing CSS
    • Controlling Layout

  3. Extending APEX  [16:45 mins]
    • Adding JavaScript to your Application
    • Adding Visual Effects to your Application
    • Loading Delimited Data
    • Inserting Multimedia to your Application
    • Consume an Item Plug-in

  4. Deploying Dynamic Actions  [15:36 mins]
    • Getting Data from the DB without Submitting a Page
    • Updating the Database without Submitting a Page
    • Disabling Fields based on Item Selection
    • Refreshing a Report like Google Search
    • Adding Browser Level Item Validation

  5. Reporting from APEX  [18:34 mins]
    • Creating a Hidden Report and Linking CSV Downloads to a Button
    • Creating an Interactive Report
    • Configuring an Interactive Report
    • Understanding an Interactive Report Detail View
    • Reporting using BI Publisher

  6. Using Supplied APEX APIs  [16:21 mins]
    • Processing Custom Tabular Forms
    • Reading a Checkbox Programmatically
    • Using
    • Counting Clicks with APEX_util.count_click
    • Managing your Workspace with Supplied APIs

  7. Looking closer at the APEX Environment  [14:07 mins]
    • Setting up Application Subscriptions
    • Debugging an APEX Application
    • Debugging using the Browser
    • Deploying and Managing APEX with SQL Developer
    • Expanding the Development Environment
  8. Configuring APEX Security  [17:10 mins]
    • Securing your Application with Custom Authentication
    • Protecting your Pages with Authorization Schemes
    • Configuring Session State Protection
    • Cross-site Scripting
    • Mitigating SQL Injection



Scott Wesley

Scott's been working with Oracle products since the turn of the century. Years spanning retail, government, finance, and construction sectors, Scott has actively researched and applied cutting edge technologies from the Oracle product range. As part of the Sage Computing Services team, Scott is a systems consultant and trainer specialising in Oracle Application Express, PL/SQL, Oracle Forms/Reports & SQL; supplementing this with requirements analysis and design. Occasionally you'll find him on the OTN forums, AskTom, PL/SQL Challenge, or helping with (and presenting at) Australian Oracle User Group (AUSOUG) events.
Sorry, we don't have any reviews for this video yet.

Sorry, there are currently no downloads available for this video.

Code Downloads

Download the code and support files for this video.

Support, complaints and feedback.

Packt is committed to making Packt Video courses a valuable, useful way for IT professionals to learn new skills. We have made every effort to ensure that this course reaches the required standard and will work on our customer's devices. Please go to our support page.

What you will learn from this video course

  • 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

Who this video course is for

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. Experience with JavaScript is not required. This course is aimed at beginner to intermediate developers, providing the foundation for exploring the advanced.

In Detail

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.


Screenshots from the course

Creating an Application

Adding multimedia to your application

Creating Interactive Reports

Debugging an Application

Authorization Scheme


Packt video courses are designed to cover the breadth of the topic in short, hands-on, task-based videos. Each course is divided into short manageable sections, so you can watch the whole thing or jump to the bit you need. The focus is on practical instructions and screencasts showing you how to get the job done.

Each video encapsulates a certain topic, but the entire course ties together so it's best executed from start to finish. Code is provided to help you with the steps required to carry out each topic.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software