with APEX 5.0

24 Pages·2014·1.03 MB·English

by  Duarte, Inc.

Rapid Application Development
with APEX 5.0

Anthony Rayner
Principal Member of Technical Staff
Oracle Application Express
Oracle UK
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.
Agenda
 APEX – A Rapid History
 APEX 5.0
– Page Designer
– Universal Interface and Theme Updates
– Modal Dialogs
– Mobile Enhancements
– Interactive Report Enhancements
 Conclusion

3 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Oracle Application Express
A Rapid History
4 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Oracle Application Express (Oracle APEX)
A Rapid 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
5 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
APEX 5.0
Page Designer

6 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Page Designer
 Create and edit page elements within a single page design view
 No need for different edit screens to edit different components
 Highly configurable user interface:
– Customize and refine view of
page specific to current focus
– Slideable panels
– Hide / show groupings
– Zoom
7 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
8 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Page Designer – Design Principles
 Create new elements using drag & drop or menu shortcuts
 Update multiple page elements at once
 Utilize “Undo” and “Redo” to revert changes made
 “Apply Changes” commits all pending changes to database
9 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Demo: Page Designer
10 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.