<Insert Picture Here>
Oracle Application Express 4.0
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.
The development, release, and timing of any
features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.
© 2009 Oracle Corporation
APEX 4.0 New Features
• Websheets
• Improved Charting
• REST Web Services
• Improved Application Builder
• Improved Interactive Reports
• Declarative Tabular Forms
• AJAX Client-Side Validations
• Improved Tree Controls
• Improved Error Handling
© 2009 Oracle Corporation
APEX 4.0 New Features
• Dynamic Actions
• Plug-Ins
• Integrate jQuery and jQuery UI
• Improved Item Properties
• Additional Attributes
• Textareas: Resizable
• Combo Box
(editable select list)
• Javascript Date pickers
© 2009 Oracle Corporation
Introducing Websheets
• Editable data grid
• Single point of truth
• Multi-user data tracking
• Designed for Business Users
• No programming required
• Multi-tenanted and self-service
• Incorporates “sharing” model (ACL)
• Includes validations, LOVs, column typing
• Consolidates data within an Oracle Database
© 2009 Oracle Corporation
Why Websheets
• Designed so “anyone” can build & deploy web based data
entry and reporting applications
• Experienced APEX developers can develop even faster
• Broadening the APEX Community
• No need to create Tables, Triggers, Sequences
• Simplified declarations:
Report layout
Form layout / List of values
• “Builder” integrated with “Runtime”
• Integrated attachments, tags, notes…
© 2009 Oracle Corporation
APEX Applications vs Websheets
APEX Applications
Database Objects
Created using SQL
Automatically managed
(APEX$ tables)
Primary Key
Triggers and sequences
Automatically managed
Created using wizards
Defined using runtime UI
Report Layout
Created using SQL
Defined using runtime UI
List of Values
SQL or Static
Defined using runtime UI
Page Flow
Controlled by branches
Form Layout
Items and regions
Column groups
Look and Feel
Themes and templates
Basic control
© 2009 Oracle Corporation
Improved Charting
• New charting engine (AnyChart 5.1) = faster, better
graphics and decreased rendering time
• Support for Maps & Gantts
• New Features:
• Scrolling support
• Interactive labels
• Markers in legends
• Multiple data markers
• Context menu localization
• All chart types can be combined within an interactive
dashboard: Charts, gauges, maps, Gantt, etc.
© 2009 Oracle Corporation
REST Web Services
• Incorporating new declarative APEX component
• Utilizes a simpler architecture than SOAP style Web
• Typically parameters are passed to a REST Web service
as part of the URL and an XML document is returned
• Many popular public Web services provided by Google,
Yahoo, Amazon and PayPal use the REST architecture
• Some Web Service providers use the REST architecture
© 2009 Oracle Corporation
Improved Application Builder
• New look and feel
• Improved navigation
• Improved Administration
• IR’s everywhere
• Integrated ‘Application
Search’ capabilities
© 2009 Oracle Corporation
Improved Interactive Reports
Integrated Report, Icon & Detail Views
Calendar Views
Inline Edit Hooks
Compound filter expressions
Email notifications
Group By
Saved Reports
• Developer Supplied
• Personal (Existing)
• Shared
• Download to searchable HTML
• More granular printing capabilities
© 2009 Oracle Corporation
Dynamic Actions
• Provides a way to define client-side behavior
declaratively within Application Express, without the need
to know JavaScript
• Simple Wizard to create
• Select Page Item
• Select Condition (e.g. equal to, greater than, is null, in
list, JavaScript expression, etc.)
• Enter value
• Select Action (Show, Hide, Enable, Show Item Row)
• Enter list of items
• Add Condition (Optional)
© 2009 Oracle Corporation
• Easy way to enhance the existing built-in functionality of
Oracle APEX with new item types, region types, dynamic
actions, etc.
• Developers use in similar fashion to native widgets
• Wizard support and declarative setting of attributes
• Included in APEX application export
• By providing this plug-in system in APEX, we want to
engage the APEX community to create a rich ecosystem
around Oracle APEX
© 2009 Oracle Corporation
Oracle APEX Listener
• Java based
• mod_plsql replacement
• Support latest APEX releases
• File system caching *
• FOP transformations to PDF *
• Improved file upload *
• To be certified against Web Logic,
Tomcat and OC4J
• Extensible
• Workload Capture *
* Requires APEX 4.0
© 2009 Oracle Corporation
Teamspace - Packaged Application
• First “professional grade” packaged application
• Designed as collaborative environment enabling users to
track tasks and events, share documents and links, and
participate in discussion forums
• Example of a rich Web 2.0 UI that can be built with
Application Express
• You can deconstruct it to learn how the user interface
works or customize it for your organization
© 2009 Oracle Corporation
APEX 4.0 Summary
• Continues the APEX Vision
• Express-ier
• Declarative Web 2.0 Magic
• Greater Extensibility
© 2009 Oracle Corporation
© 2008 Oracle Corporation – Proprietary
© 2009 Oracle Corporation

Oracle Application Express 4.0