1 / 52

Oracle Application Express 4.2 Anthony Rayner, Product Development, Database Tools

Oracle Application Express 4.2 Anthony Rayner, Product Development, Database Tools.

pia
Download Presentation

Oracle Application Express 4.2 Anthony Rayner, Product Development, Database Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Application Express 4.2Anthony Rayner, Product Development, Database Tools

  2. 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.

  3. Skip Overview Agenda • Oracle Application Express Overview • New Features in 4.2 • Beyond Oracle APEX 4.2… • Q&A

  4. Oracle Application Express Overview Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost feature of the Oracle database.

  5. Oracle Application Express (Oracle APEX) • Browser Based Application Development

  6. Oracle Application Express (Oracle APEX) Rapid Browser Based Development Leverage SQL Skills • Benefits Point your browser and start developing Build reports and charts using SQL Self Service Provisioning Runs within Database Out-of-the-box elastic private cloud service Simple to manage, highly scalable

  7. Oracle Application Express (Oracle APEX) • Architectural Overview • Simple 2-Tier Architecture • Pages dynamically rendered using database Meta data • No code generation or file based compilation • Runs everywhere Oracle Database runs

  8. Oracle Application Express (Oracle APEX) • Distributed with • Oracle Enterprise Edition • Oracle Standard Edition • Oracle Standard Edition One • Oracle XE 10.2, 11.2 • Supported Database Releases • 10gR2, 11gR1, 11gR2, 12 • Exadata, ODA, RAC • Fully supported no-cost feature of Oracle DB

  9. Oracle Application Express (Oracle APEX) • History

  10. Oracle Application Express (Oracle APEX) • Community • Estimated 400,000 developers worldwide • Over 120 consulting companies worldwide • Over 75 bloggers • 3rd most popular forum on OTN • Web sites dedicated to plug-ins, themes, tools • 64 sessions and > 300 APEX Developers at ODTUG KScope 12

  11. Oracle Application Express (Oracle APEX) • Books

  12. Oracle Application Express (Oracle APEX) • Version in Use (as of 02-NOV-2012)

  13. Agenda • Oracle Application Express Overview • New Features in 4.2 • Beyond Oracle APEX 4.2… • Q&A

  14. Mobile Application Builder • Declarative support for building mobile web applications • APEX Applications support multiple user interfaces: e.g. Desktop and Smartphone • Mobile pages use jQuery Mobile through jQuery Mobile based theme and templates • HTML5 based charts and new HTML5 item types

  15. Mobile Application Builder • User Interfaces • APEX applications can be associated with multiple user interfaces • Applications can include desktop and mobile specific pages • Each Page supports only one user interface • Each user interface is associated with one theme • User Interface defines device specific login URLs, home page URLs and device auto detection • Page 0 replaced by Global Page(s)

  16. Mobile Application Builder Application UI Types 1 1 1 1 1 n 1 n n User Interfaces Themes 1 1 1 n n Plug-Ins Pages

  17. Mobile Themes and Templates • Provide Themes & HTML Templates to support the development of Mobile applications • Theme 50 • Declarative support to specify JavaScript & CSS • Default Mobile Page and Popup Transition Type

  18. Mobile Themes and Templates • Support Content Delivery Networks for jQuery files • New #PAGE_STATIC_ID# substitution string added to page templates • Easy to Create your own Mobile themes – Check out jQuery Mobile built-in theming frameworkThemeroller for ideas:http://jquerymobile.com/themeroller/

  19. List View Region Type • jQuery Mobile List view using data-role="listview" attribute • Server Side AJAX search • AJAX based pagination • Support of the "Refresh" dynamic action

  20. HTML5 Charts • HTML5 charts - AnyChart version 6 • 2 Chart Rendering options • Flash Preferred • HTML5 • Conditional Display of Chart Series • HTML Chart region plug-in

  21. HTML5 Item Types • New Items Types: • Slider • Date Picker (HTML 5) • Yes/No (Flip Toggle Switch) • Incorporate HTML 5 attributes: • HTML5 placeholder attribute • HTML5 types EMAIL, TEL and URL for Textfield • HTML5 “required” attribute • Display Orientation attribute

  22. Mobile Calendars • Added mobile-friendly calendar templates • Added new calendar view option: • List view Demo

  23. Responsive Web Design (RWD) an approach to web design in which a designer intends to provide an optimal viewing experience—easy reading and navigation with a minimum of resizing, panning, and scrolling—across a wide range of devices(from desktop computer monitors to mobile phones). (Wikipedia)

  24. 25

  25. 26

  26. 27

  27. 28

  28. 29

  29. Themes and Templates Cell Phone / Tablet • Responsive Design = Theme 25 Desktop Demo

  30. Dynamic Action Enhancements • Streamline creation (no more ‘Standard’ and ‘Advanced’) • Enable jQuery Mobile • Expose jQuery Mobile events through Dynamic Actions e.g. swipe, touch, tap/hold, orientation • Provide ‘Custom’ event support • Declarative support for buttons to be the ‘Affected Element’ • AJAX based Dynamic Actions to work asynchronously • Chart and List View ‘Refresh’ Dynamic Actions support Demo

  31. Plug-In Enhancements • Increased Number of Custom Attributes to 25 • NewAPIs in apex_plugin_util to better support custom plug-in attributes of type "Region Column Name " • New Standard Region Type Plug-in Settings: • ‘Fetched Rows’ • ‘No Data Found Message’ • Add support for media queries and IE conditions to apex_css and apex_javascript APIs

  32. Packaged Applications • Suite of Business Productivity applications installable with only a few clicks • Production-ready applications include Project Management, Shared Calendars, Checklists, etc. • Support for Third party applications, sharing same infrastructure and user pool

  33. Packaged Applications • Productivity Apps • Project Tracker • Checklist Manager • Customer Tracker • Group Calendar • Product Features • Bug Tracker • Asset Manager • Document Library • Survey Builder • Sample Code • Calendars • Charts • Data Loading • Dynamic Actions • Interactive Reports • Master-Detail Forms • Tabular Forms • Trees • Sample Database Application • Sample Websheets

  34. Data Upload Enhancements • Allow up to 3 columns in Look-up Definition • Expand transformation rules to include PL/SQL • Provide aliases for column names Demo

  35. Other New Features in APEX 4.2 • Enhanced Application Builder User Interface • Dedicated JavaScript / CSS Attributes • Grid Layout • Named Branches • Read-only attribute for Pages and Regions • Interactive Report and Websheet enhancements • Instance Administration improvements

  36. Other, Other New Features in APEX 4.2 • Item limit per page raised to 200 • Shared Session State across Applications • JavaScript library rewrite / “Legacy” JavaScript • New jQuery, AnyGantt and CKEditor charts versions • SQL Workshop Date Format • Publish Translations from command-line • Improved Accessibility Demo

  37. RESTful Web Services* • Interaction with data sources through the use of Uniform Resource Identifiers (URIs) * • Standard method of accessing data in the Oracle Cloud • Ability to create services which implement any SQL statement or PL/SQL procedure • Data returned in JSON or CSV format, or additionally through PL/SQL * Requires APEX Listener 2.0

  38. Instance Security: Require outbound HTTPS • Require all outbound requests to be over HTTPS. • Region of type URL, Web Services

  39. Instance Security: Instance-wide proxy • Require all outbound HTTP(s) traffic use an instance-wide proxy.

  40. Instance Security: Restricted Characters • Input validation • Declarative control over which characters can be entered into session state

  41. Instance Security: Log Switch (Data Retention) • Retention of all logs is variable • Greater log switch interval can result in less performance

  42. Resource Manager Consumer Group • All requests from a workspace can be confined to a resource consumer group

  43. Partitioning of APEX runtime tables • Supported method to partition APEX runtime tables (session data, activity logs and indexes)

  44. Agenda • Oracle Application Express Overview • New Features in 4.2 • Beyond Oracle APEX 4.2… • Q&A

  45. http://apex.oracle.com/pls/apex/f?p=55447:1

  46. Beyond Oracle APEX 4.2… • Proposed Future Release Features • Modal Dialogs • Multiple Tabular Forms on one page • Master-Detail-Detail support • Multiple Interactive Reports on one page

  47. Agenda • Oracle Application Express Overview • New Features in 4.2 • Beyond Oracle APEX 4.2… • Q&A

More Related