Oracle Application Express 5 1 Overview Name Title

Oracle Application Express 5. 1 Overview [Name] [Title] [Date] Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 2

Oracle Application Express Introduction Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 3

Oracle Application Express Database-centric web application development framework Develop desktop and mobile web apps Visualize and maintain database data Leverage SQL Skills and database capabilities Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 4

Oracle Application Express Distinguishing Characteristics App Development IDE is a web browser. No client software needed App definitions are stored in the database as meta data. Declarative – No code generation Page generation is efficient with only one request and one response. Data processing done in the Database Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 5

Oracle Application Express Develop faster, release more frequently Pre-built controls for security, authentication, database interaction, validation, session management and more… Go from prototype to production in minutes Develop Customize Deliver Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 6

Oracle Application Express Declarative high productivity App Dev with optional snippet and procedural coding for high control Components & Data Access Navigation & Page Flow Business Logic Access Control & Session Management pages, reports, charts, grids, forms Page Branching Menu Navigation Lists Component Simple Validations and Computations Browser Client Interaction Drag & Drop Layout User Interface Themes No Code Drill Down Links Modal Dialogs Automatic Session Management Input Fields text area, select list, checkbox, switches, shuttle, radio group Icon Library Integration High Productivity Citizen Developer 4 GL meta-data driven development Declarative Styling Authorizations Declarative Client Actions Declarative Theming REST Conditional Flows & Branching PL/SQL Snippets Conditional Display Logic Authentication Analytics, Multimedia Text, Spatial SQL Component Properties Component Library + Wizards Java. Script Snippets CSS Snippets Low Code More Control Power User / Departmental Developer Extend using code snippets and plug-ins Plug-in Development Punch-outs and Call Backs PL/SQL Collections Custom Authentication 3 rd Party Java. Script Programs + Libraries Integration Template and Theme Development HTML & CSS Programmatic High Control IT Professional 3 GL Procedural Code / Libraries Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 7

Oracle Application Express Use Cases Developing opportunistic & self service web apps Extending enterprise application solutions Migrating file based and client server apps to the web Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 8

Oracle Application Express No cost feature of the Oracle Database • No-cost fully supported feature • Any number of apps, developers & end-users • Specialized Oracle Support Team • 11 g. R 1, 11 g. R 2, 12 c • All DB editions: EE, SE 1, XE • Included with Oracle Cloud Services • Schema Service • Exadata Express Service • Database as a Service • No cost evaluation http: //apex. oracle. com • Easy to install • Included by default with all editions of Oracle database • Download latest release from http: //otn. oracle. com/apex Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 9

Oracle Application Express 3 Tier Architecture Data Schemas Oracle APEX Engine Oracle Database Browser Mid Tier Database Tier ORDS = Oracle REST Data Services Copyright © 2016 Oracle and/or its affiliates. All rights reserved. | 1

Oracle Application Express History 1. 5 2. 0 3. 0 2. 1 4. 0 3. 1 3. 2 5. 0 4. 1 4. 2 5. 1 2. 2 Exadata Service Schema Service Oracle Database Cloud Services with Application Express 2012 Exadata Express DBaa. S 2013 2014 2015 2016 2017 Copyright © 2016 Oracle and/or its affiliates. All rights reserved. |

Data Sources Utilize the Oracle Database / Web Services Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 14

Single Database Instance / Multiple Workspaces Easily managed with optional self-service provisioning • Workspaces used to define application definitions / Schemas hold data • Many-to-many relationship between Workspaces and Schemas • Instance Administrators manage the environment and schema access • Departments can request more space, and access to a new schema • For example, http: //apex. oraclecorp. com has over 3, 000 Workspaces for every line of business in Oracle Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 15

Development / Deployment Options Local On-Premise Cloud • Install on stand-alone laptops using Oracle Express Edition (XE) or full database version • Simply upgrade APEX to the required version • Can work completely disconnected • Typically run by the IT Department • IT generally both production operations service, and a service provider • Departments responsible for application development • Deploy Internet applications • Leveraged for fast application development, user acceptance and training. • Prototyping & Proof-of-Concept • Consulting companies develop for deployment on customer premise Browser based application development framework enables efficient development & deployment Shoot someone a URL – Check this out – Application Development Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 16

Oracle Application Express Community • Over 400, 00 developers worldwide • Estimated from support requests, downloads, conferences, discussion forum activity • More than 100 active bloggers http: //odtug. com/apex • http: //apex. oracle. com/community Consulting companies, books, success stories, quotes, commercial apps Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 17 1

Oracle Application Express Internet Sites built with Oracle APEX http: //builtwithapex. com • Showcases large diversity of types of applications and different themes • Launched October, 2016 • > 100 sites published, more being added daily Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 18 1

Oracle Application Express Community site built by the community for the community http: //apex. world • Community-authored site providing: • Plug-ins • Slack discussion channels • Twitter feeds • News • Jobs • Conferences • Meetups Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 19 1

Useful Links Collateral, Resources and Hosted Services • Oracle Technology Network • APEX Community • Oracle Learning Library • Hosted evaluation site • APEX Cloud Service http: //otn. oracle. com/apex http: //apex. oracle. com/community http: //www. oracle. com/oll http: //apex. oracle. com http: //cloud. oracle. com Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 20

Skip Oracle Application Express Product Components Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 21

Home Page Comprehensive Development IDE, Web Application Development, and SQL Database Development Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 22

Application Builder Integrated Development Environment (IDE) with Application Development Graphical “Page Designer” Features tight SQL and PL/SQL integration Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 23

Application Builder - Page Designer Powerful browser-based IDE • Multiple trees to view the page components • Visualization of the page within the Grid Layout, and associated Gallery, allowing you to drag and drop components • Update multiple attributes without leaving the page in the Property Editor • Advanced Code Editor for defining SQL, HTML, CSS and text sections • Highly configurable user interface: – Customize and refine view of page specific to current focus – Slideable panels – Drag and drop tabs Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 24

Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 25

Application Builder – Code Editor Available for maintaining SQL, PL/SQL, Java. Script, HTML, CSS, and large text sections • Syntax Highlighting • Undo / Redo • Find/Replace • Auto completion • Code validation • Used in Page Designer, Component View and SQL Workshop Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 26

Application Builder - Universal Theme Overview • New default theme for APEX applications • Uses responsive HTML 5 templates • Grid-layout for HTML forms • Modern flat-look • Ships with a variety of pre-built theme styles • Older themes still available as legacy themes, and will remain part of the product for backwards compatibility Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 27

Application Builder - Universal Theme Template Options • Declarative CSS modifiers for HTML 5 templates • Enables developers to declaratively apply styles like borders, padding, icons, colors, size, etc. • Uses easy-to-understand, descriptive names • Available for most template types: – Page, Region, Report, Breadcrumb, List, Item, Button • Significantly reduces the number of required templates for a theme Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 28

Application Builder - Universal Theme Styles and Theme Roller • Theme Styles provide a variety of different color schemes and styles for a single theme • Defined as CSS file that is included in addition to theme’s base CSS file • Universal Theme includes several pre-built styles • Additional styles can be easily generated using the built-in Theme Roller utility Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 29

SQL Workshop Browser based maintenance of database objects and data Designed to meet application developers’ needs, especially in hosted environments Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 30

Team Development Collaborate with colleges, track project details with associations to application pages. Life cycle development: design, develop, deploy, view customer feedback, enhance, re-deploy. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 31

Packaged Applications • Robust suite of productivity and sample applications. • Illustrates best practices and design patterns. • Template to start customization (e. g. unlock your packaged app). • Upgraded with every release. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 32

Skip Oracle Application Express Features Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 33

Interactive Reports Powerful Reporting capabilities End-user customizable Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 34

Interactive Grid • Modern, rich & interactive multi-row editing component • Use of existing Item types • Declarative support for Cascading LOVs and Dynamic Actions • Upgrade utility for Tabular Forms • Master Detail / Detail Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 35 3

Interactive Grid Master Detail Layout – N-levels wide or deep Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 36 3

Charting Engine Declarative support for Oracle JET Data Visualization Components • Based on Oracle JET Data Visualization Components • Oracle Jet (Java. Script Extension Toolkit) is open source • Java. Script-based solution, data being provided in JSON format • Highly Customizable – Using ‘Java. Script code’ to provide function to be called when chart is initialized – Using Dynamic Actions to add interactive behavior • Built-in Accessibility Support • Built-in Responsive Design Support Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 37 3

Charting Engine Declarative support for Oracle JET Data Visualization Components Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 38 3

Calendars Different views, drag and drop capability, with mobile specific templates Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 39

List-based Navigation Menus • Alternative to using traditional tabs • Available as top navigation menu and side menu • Implemented as standard APEX lists • Supports multi-level hierarchical menu structures • Provides accessible pull-down menus • Type of navigation determined by themes – Universal Theme uses lists • Migration of older one-level tabs to lists when switching themes Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 40

Dynamic Actions Declaratively define rich client-side interactivity without writing Java. Script or AJAX Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 41

Modal Dialogs Readily switch between normal, modal, and non-modal page mode • Replacement for Popup Windows • A modal dialog is a stand-alone page, not a region on a page • Any page be created as a dialog page • Supports all the functionality of a regular page, incl. computations, validations, processes, and branches Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 42

Plug-Ins Extend applications with custom components such as items and regions Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 43

RESTful Web Services Emit RESTful Web Services from the database for use in your SOA environment • Interaction with data sources through 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 Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 44

Websheets Allow end-users to build / maintain WIKI like pages with database capabilities • Database enabled WIKI • Annotations (easily add files, links, notes, and tags) • Use [[SQL ]] tag • Presentation mode • Multi user Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 45

Skip Oracle Application Express Examples of how Oracle uses Oracle APEX Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 46

Oracle Store [Internet Application] http: //shop. oracle. com Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 47

Oracle Learning Library [Internet Application] http: //www. oracle. com/oll Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 48

HR Directory [Internal Only – Intranet Application] ARIA People • Nightly download of HR data • Employees can update profile, upload picture, add links. . . • Used to contact employees, see Org. Chart, etc. • Average ~ 1. 5 million page views / day ( > 50 page views / sec for hours ) • Median execution time of 0. 04 seconds Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 49

Oracle Application Express – Success Story ORACLE TEAM USA Portals and Mobile Solutions “Sailors have access to an Oracle Application Express–based mobile app that automates the 250 -item checklist necessary to prep the boat for sailing. “It’s a perfect use of database and mobile technology, ” says Burns. “Oracle Application Express is really a powerful tool for widespread mobile data access. ” Ian “Fresh” Burns Design Team Coordinator Oracle Team USA Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 50

Skip Oracle Application Express Leveraging Oracle Database Features Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 51

Oracle Application Express (APEX 5) Security features of the Oracle Database Works with APEX Transparent Data Encryption Database Vault Audit Vault Database Firewall Key Vault Data Redaction Data Masking Auditing Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 52 52

Oracle Database as a Service High Availability features of the Oracle Database Works with APEX Real Application Clusters Data Guard Active Data Guard Golden Gate Secure Backup Online Reorganization Edition-Based Redefinition Flashback, Total Recall Automated Rolling Upgrade of Database Failover to the Cloud Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 53 53

Oracle Application Express (APEX 5) High Performance features of the Oracle Database Works with APEX Multi version read consistency Row level locking In-Memory Compression Partitioning Hadoop, Big Data SQL, R Cost based query optimizer Scale-out with Oracle RAC Exadata Smartscan & Infiniband Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 54 54

Oracle Application Express (APEX 5) Simplified consolidation and deployment with Oracle Multitenant Works with APEX PDB Deployment PDB Cloning PDB Self Service App PDB Migration High Density Consolidation Automated Provisioning and Configuration PDB Resource Management Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 55 55

Oracle Application Express (APEX 5) Database Application Development Features Works with APEX SQL and PL/SQL Java in Database Analytics Text Regular Expressions Spatial Pattern Matching Database XML SQL PL/SQL Database JSON AQ Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 56 56

Oracle Application Express Summary Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 57

Oracle Application Express Summary • Used by real customers for real applications: Used for both opportunistic and mission critical apps that service tens of thousands of users. • Well Established Product : First released in 2004 • Continually growing: Oracle install base is adopting Oracle APEX for increasing numbers of projects, and is increasingly an approved corporate IT standard. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 58

Oracle Application Express Summary • Aligned with industry trends: Strong support for HTML 5 development frameworks, Modern & responsive CSS 3 UI, integrated Java. Script libraries, Browser-based, self-service provisioning, flexible development and deployment including cloud services. • Consistent with Oracle developers skill set: SQL, PL/SQL, Oracle Database. Proficiency in the Oracle database easily translates into an ability to develop web applications. Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 59

Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 60

Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 61