Oracle APEX 5.0 - New York Oracle User Group

38 Pages·2014·1.63 MB·English

by  Duarte, Inc.

Oracle APEX 5.0
Universal Theme & Template Options
Marc Sewtz
Senior Software Development Manager
Oracle Application Express
Oracle, New York, NY
The following is intended to outline Oracle’s 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.
2 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Marc Sewtz
Senior Software Development Manager
Oracle Application Express / Database Tools
 Working for Oracle in New York since 1998
 Joined Database Tools group in 2002
 Twitter: @msewtz
 APEX on Twitter: #ORCLAPEX
 Blog: http://marcsewtz.blogspot.com
3 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Agenda
 APEX Overview
 Modern UI Design with APEX 5.0
 Universal Theme &
Template Options
4 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Oracle Application Express
Overview
5 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Oracle Application Express (Oracle APEX)
Fully supported no-cost feature of Oracle DB
• Browser-based Development Tool
• Build and deploy Web-based applications
for Desktops and Mobile devices
• Distributed with
– Oracle Enterprise Edition
– Oracle Standard Edition/ Standard Edition One
– Oracle XE
• Supported Database Releases
– 10gR2, 11gR1 and 11gR2, 12c
6 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Oracle REST Data Services
• Formerly known as Oracle APEX Listener
• Directs calls to APEX applications to the
APEX run-time engine
• Accepts RESTful Web Service call URIs
and directs them to the appropriate SQL
statement or PL/SQL block
• Marshals data returned from SQL
statements into JSON or .csv format
7 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Oracle Application Express (Oracle APEX)
History
HTML DB 1.5 Application Express 2.1 Application Express 3.1 Application Express 4.0 Application Express 4.2
 First Release  Oracle XE  Interactive Reports  Websheets  Mobile
HTML DB 1.6 Application Express 2.2  Dynamic Actions  HTML5
 Themes  Packaged Applications  Plug-Ins  Packaged Apps
 Team Development
2004 2005 2006 2007 2008 2009 2010 2011 2012
HTML DB 2.0 Application Express 3.0 Application Express 3.2 Application Express 4.1
 SQL Workshop  Flash Charts  Oracle Forms to APEX  Data Upload
 PDF Printing Conversion  Error Handling
 Access Migration  ROWID
8 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Oracle HTML DB
9 Copyright©2013, Oracle and/or its affiliates. All rights reserved.
Oracle Application Express 3.0
10 Copyright©2013, Oracle and/or its affiliates. All rights reserved.