Oracle Application Express Level 2

2 days


This level 2 course is for anyone has attended the level 1 course and wants to learn more about Application Express (APEX)

Course Outline

Adding Features to Your Application

  • BLOB handling
  • Sending E-Mails and attachments
  • Creating Tabular Forms Manually
  • Using Collections
  • User defined Error Handling
  • Creating Data Load Pages
  • Creating Trees

Introduction to Dynamic Actions

  • What are Dynamic Actions?
  • Creating a Set Value Dynamic Action with a SQL Statement
  • Create a Set Value Dynamic Action Using PL/SQL
  • Changing the class when an item is null
  • Disabling a Button When Items are Null
  • Refreshing the data in a report using custom filters

Introduction to Plug-ins

  • Identifying the steps to creating and using a plug-in in your Application
  • Importing a plug-in
  • Creating a plug-in

Creating Mobile Applications

  • Add a mobile user interface to a database application
  • Creating List View
  • Creating and linking a form to the application
  • Add a link on the Home page
  • Use some of the HTML5 item types
  • Adding a HTML5 chart to your application

Creating Dynamic Content

  • Understanding Conditional Logic
  • Dynamic PL/SQL Content
  • Creating PL/SQL Reports


  • What are Websheets?
  • Websheet verses Database Applications
  • Creating Websheets
  • Editing Properties
  • Running the WebsheetPages
  • Pages and Sections
  • Incorporating a Text Section
  • Incorporating a Data Section
  • Incorporating a Chart Section
  • Incorporating a PL/SQL Section
  • Incorporating a Navigation Section
  • Adding Annotations to a Page
  • Sharing Websheets with Users

Team Development Functionality

  • Tracking features, milestones, bugs and to dos
  • Managing Feedback

Related Courses


Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London2 1066 £1066 2020-01-16
London London2 1066 £1066 2020-01-16