1 / 37

Hidden Gems of APEX

Hidden Gems of APEX. David Gale Software Engineer Oracle Application Express November, 2014. “I didn’t know APEX could do that”. Oracle Application Express. David Gale has been working with Oracle Application Express since 2009 (v. 4.0).

berenice-shannon
Download Presentation

Hidden Gems of APEX

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. Hidden Gems of APEX David Gale Software Engineer Oracle Application Express November, 2014

  2. “I didn’t know APEX could do that” Oracle Application Express

  3. David Gale has been working with Oracle Application Express since 2009 (v. 4.0). He has been part of the APEX development team since joining Oracle in 2011. DAVID GALE Software Engineer Oracle Application Express Database Tools | Server Technologies 1900 Oracle Way Reston Virginia 20190 phone +1-703-364-2613 mobile +1-703-268-9040 david.s.gale@oracle.com twitter @david_s_gale

  4. Introduction Oracle Application Express

  5. Oracle Application Express • Database-centric development tool for Oracle Database application development • Targeted at Web-based developers who know SQL and PL/SQL • Develop Desktop and Mobile applications • 100% Browser-based Development and Runtime • Declarative framework for rapid application definition, and full application life cycle. • On premise, on laptop, on cloud, on RAC, any platform Oracle DB is available

  6. History • Also known as Oracle APEX (a'peks) • APEX 4.2 Dot Releases • ImprovedPackaged Apps • APEX 4.2 • Mobile • HTML5 • Packaged Apps • APEX 3.1 • Interactive Reports • APEX 4.0 • Websheets • Dynamic Actions • Plug-Ins • Team Development • HTML DB 1.5 • First Release • HTML DB 1.6 • UI Themes • APEX 2.1 • Oracle XE • APEX 2.2 • Supporting DB Objects for full app installation and upgrade 4.2.5 4.2.1 4.2.2, 3, 4 2012 2013 2004 2005 2006 2007 2008 2009 2010 2011 2014 / 5 • HTML DB 2.0 • SQL Workshop • APEX 4.1 • Data Upload • Error Handling • ROWID • Application Express 5.0* • Universal Theme • Page Designer • UI Modernization • HTML5 Plugins • APEX 3.0 • Flash Charts • PDF Printing • Access Migration • APEX 3.2 • Oracle Forms to APEX Conversion Development initiated August 1999 *Available in Early Adopter Only (apexea.oracle.com)

  7. Fully supported no-cost feature of the Oracle Database • Supported as a no-cost feature of the Oracle Database • No cost feature of database 10gR2 (10.2.0.4 +), 11gR1, 11gR2, 12c • Any number of developers, applications, any number of end-users • Specialized Oracle Support Team – Included with Database Maintenance Agreement • All database editions: EE, SE, SE1, XE • Exadata, ODA, RAC, Partitioning, Compression, InMemory, Multitenant… • Distribution • Distributed with all editions of Oracle database 11g and 12c • Available as a download from OTN • Oracle Cloud Services • “Oracle Database Cloud Service” aka schema since October 2012. Sold as a fully managed service with 1GB free trial, and 5, 20, 50 GB paid services. • Available as “development only” customer evaluation service on http://apex.oracle.com

  8. Hidden Gem: APEX Data Dictionary Oracle Application Express

  9. APEX Data Dictionary • Set of views of (most) metadata for Workspaces, Applications, etc. • Accessible through SQL • Application → Utilities → Application Express Views

  10. APEX Data Dictionary

  11. APEX Data Dictionary (Tree View)

  12. Hidden Gem: APEX Advisor Oracle Application Express

  13. APEX Advisor • Automated test suite for common APEX errors and security vulnerabilities • Application → Utilities → Advisor

  14. APEX Advisor

  15. Hidden Gem: Application Search Oracle Application Express

  16. Application Search • Several shortcuts • <page> - Open page in editor (current application) • <application>:<page> - Open page in editor • <application>:s – Application Shared Components (new in 5.0) • Search prior to opening an application: full workspace search

  17. Hidden Gem: SQL Workshop Utilities Oracle Application Express

  18. SQL Workshop Utilities • Suite of tools for working with database objects • Data loading • DDL generation • API package creation • Schema comparison • …and more… • SQL Workshop → Utilities

  19. SQL Workshop Utilities

  20. Hidden Gem: Query on Selected Table Oracle Application Express

  21. Query on Selected Table • Part of the Find (not search) functionality • Automatically generates select statement with all column names • Better than “select *” for usability and maintenance • Find → Tables

  22. Query on Selected Table

  23. Hidden Gem: PL/SQL Column Headings Oracle Application Express

  24. PL/SQL Column Headings • Classic Reports only • Combine with “SQL Query (PL/SQL function body returning SQL query)” report type for dynamic reports • Function returning colon-separated list of column headings • Can use apex_util.set_report_column_format(…) to specify format masks at the same time

  25. PL/SQL Column Headings

  26. Hidden Gem: Page Items to Submit Oracle Application Express

  27. Page Items to Submit • Automatically copy page item values from DOM to session state • Attribute of reports and PL/SQL dynamic action steps • Enables partial page refresh for reports, complex dynamic actions

  28. Page Items to Submit

  29. Page Items to Submit

  30. Hidden Gem: Packaged Applications Oracle Application Express

  31. Packaged Applications • Suite of pre-built applications available for immediate deployment and use • Two types • Sample Applications – demonstrate specific functionality • Can be installed and inspected immediately • Productivity Applications – designed to meet actual business needs • Locked upon initial installation • Fully supported by Oracle* • Active development

  32. Packaged Applications

More Related