New Features Name Title December 2016 2 Agenda 1 2 3 4 5 Oracle Application Express Overview Interactive Grid Oracle JET Charts Universal Theme Productivity Improvements Packaged Apps ID: 580712
Download Presentation The PPT/PDF document "Oracle Application Express 5.1" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1Slide2
Oracle Application Express 5.1New Features
[Name][Title]December 2016
2Slide3
Agenda
1
2
3
4
5
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
3
6
7Slide4
Agenda
1
2
3
4
5
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
4
6
7Slide5
Agenda
1
2
3
4
5
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
5
6
7Slide6
Agenda
1
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
6
2
3
4
5
6
7Slide7
Oracle Application ExpressDatabase-centric web application development framework
Develop desktop and mobile web apps
Visualize and maintain
database data
Leverage SQL Skills and database capabilities
7
Also known as Oracle APEX (āʹpěks)Slide8
Oracle Application ExpressDistinguishing Characteristics
Application Development IDE is a web browser. No client software needed
Application definitions are stored in the database as meta data.
Declarative – No code generation
Very efficient page generation - single request - single response.
Data processing done in the Database
8Slide9
Oracle Application ExpressDevelop faster, release more frequently
9Slide10
Oracle Application ExpressUse Cases
Developing opportunistic & self service web apps
Extending enterprise application solutions
Migrating file based and client server apps to the web
10Slide11
Oracle Application Express
3 Tier Architecture
Browser
Mid Tier
Database Tier
Oracle APEX
Engine
Oracle
Database
Data
Schemas
11
ORDS = Oracle REST Data ServicesSlide12
Oracle Application Express
No-cost fully supported feature
Any number of developers, apps, & end-users
Specialized Oracle Support Team
11gR1, 11gR2, 12c
All DB editions: EE, SE, SE1, XE
Included with Oracle Cloud Services
Exadata Express &
Schema services
5, 20, 50 GB
Dedicated DBaaS services
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
No cost feature of the Oracle Database
12Slide13
2012
2013
2014
2015
2016
2017
Oracle Application Express
13
1.5
2.0
3.0
4.0
5.0
2.1
2.2
3.1
3.2
4.1
4.2
5.1
Oracle Database Cloud Services
w
ith
Application
Express
History
Schema
Service
DBaaS
Exadata
Express
Exadata
ServiceSlide14
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
14
Community
Oracle Application ExpressSlide15
http://builtwithapex.com
Showcases large diversity of types of applications and different themes
Launched
October,
2016
> 100
sites published,
more
being added daily
15
Internet Sites built with Oracle APEX
Oracle Application ExpressSlide16
http://apex.world
Community-authored site providing:
Plug-ins
Slack discussion channels
Twitter feeds
News
Jobs
Conferences
Meetups
16
Community site built by the community for the community
Oracle Application ExpressSlide17
Useful LinksOracle Technology Network
http://otn.oracle.com/apexAPEX Community http://apex.oracle.com/community
Oracle Learning Library
http://www.oracle.com/oll
Hosted evaluation site
http://apex.oracle.com
APEX Cloud Service
http://cloud.oracle.com
Collateral, Resources and Hosted Services
17Slide18
Agenda
1
2
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
18
3
4
5
6
7Slide19
Interactive Grid Long-standing customer requests to enhance Tabular Forms: Support multiple tabular forms on a single pageCascading LOVsDynamic Action SupportLift 32k limitation on report rows
Motivation19Slide20
Interactive Grid Modern, rich & interactive multi-row editing componentUse of existing Item typesDeclarative support for Cascading LOVs and Dynamic Actions
Upgrade utility for Tabular FormsMaster Detail / Detail Major Features20Slide21
Interactive Grid JSON-based, lightweight Ajax communicationsClient-side and server-side validationDeclarative validations and processesSupport for bind variables to reference columns
Execution scope: all rows or only rows modified and addedColumn groups, fixed headers and frozen columnsInfinite scrolling and lazy loadingAccessible, excellent keyboard support, right-to-left support
Features
21Slide22
Interactive Grid Removal of limitations like 32k bytes per rowWarn on unsaved changesJSON-based page submissionForm not mapped to
p_t001-200 and p_v001-200All item values now stored in JSON documentAllows for > 200 page itemsArchitecture Changes
22Slide23
Interactive Grid 23
Page Layout
–
Single
GridSlide24
Interactive Grid 24
Master Detail Layout
–
N-levels wide or deepSlide25
Interactive Grid 25
Master Detail Layout
–
Any combinationSlide26
Agenda
1
2
3
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
26
4
5
6
7Slide27
Oracle JET ChartsBased on Oracle JET Data Visualization ComponentsOracle Jet (JavaScript Extension Toolkit) is open source JavaScript-based solution, data being provided in JSON format
Highly CustomizableUsing ‘JavaScript code’ to provide function to be called when chart is initializedUsing Dynamic Actions to add interactive behaviorBuilt-in Accessibility SupportBuilt-in Responsive Design SupportDeclarative support for Oracle JET Data Visualization Components
27Slide28
Oracle JET ChartsDeclarative support for Oracle JET Data Visualization Components28Slide29
Oracle JET ChartsOracle JET charts fully integrated into APEX 5.1 using Plug-In ArchitectureDeclarative Chart creation using Page Designer and WizardsUpdated Create Application wizardNew Create Chart Page wizardChart Source Definition Simplified
New Chart Types - Funnel, Area, Polar, Line with Area, RadarColor palette integrated with Universal ThemeDeclarative support for Oracle JET Data Visualization Components29Slide30
Oracle JET ChartsNo more 32k restrictionBuilt-in Document Direction Support – RTLUpgrade path from AnyChart to Oracle JET ChartsSupport for Oracle JET Charts in Interactive GridsEnhanced Sample Charts application
Declarative support for Oracle JET Data Visualization Components30Slide31
Agenda
1
2
3
4
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
31
5
6
7Slide32
Agenda
1
2
3
4
5
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
32
6
7Slide33
Developer ProductivityModern, intuitive and powerful browser-based IDEIntroduced in Application Express 5.0Cohesive User ExperienceNo context-switching when modifying multiple componentsUndo and redo changesBetter Visual Representation
Immediate visual representation of region and item layoutChanges immediately reflected across the Tree, Grid Layout and Property EditorPage Designer33Slide34
34Slide35
Developer ProductivityIntuitive Drag and DropDrag new components from the Component GalleryMove and copy existing components aroundDrag to move and copy multiple components at a time using Treee View
Enhanced Code EditorSQL and PL/SQL validation with inline errorsAuto completion, syntax highlighting, search and replace with regex supportPreferences for tabs, indentation, and color scheme.Page Designer
35Slide36
Developer ProductivityIntegrated ‘Component View’New Two Pane ModeMovable TabsProperty Editor Filter
Style and contrast enhancementsPage Designer36Slide37
Developer ProductivityLegacy Component View deprecated in APEX 5.1Will be de-supported and removed in APEX 5.2Does not support new 5.1 components like JET charts and Interactive GridDoes not support certain new attributes like new dynamic actions attributes specific to Interactive GridsDisabled by default, can be re-enabled via user preferences
Legacy Component View37Slide38
Agenda
1
2
3
4
5
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
38
6
7Slide39Slide40Slide41
41New Productivity Apps
Packaged Apps
Quick SQL
–
Quick and intuitive way to generate a relational SQL data model
Competitive Analysis
–
Create side-by-side comparisons which can be scored and charted
REST Client Assistant
–
Access RESTful services in Database or public services and map to SQL result set columnsSlide42
42Packaged Apps
Significantly Improved Productivity Apps
P-Track
Customer Tracker
Group Calendar
Live Poll
Opportunity Tracker
Improvements based on feedback from real-life use casesSlide43
43Packaged Apps
New / Improved Sample Apps
Sample Interactive Grid
–
Demonstrates read-only, pagination, editing and advanced techniques
Sample Charts
–
Completely revamped to showcase Oracle JET charts
Sample Master-Detail
–
Highlights different ways to display related tables, including Interactive Grids
Sample Projects
Sample REST ServicesSlide44
Productivity Apps - Getting Started Page
44Slide45
Productivity Apps – Display Customization
45Slide46
46
Productivity Apps – Display CustomizationSlide47
47
Vita
Vita Red
Vista
Vita Dark
Productivity Apps –
Display
CustomizationSlide48
Agenda
1
2
3
4
5
Oracle Application Express Overview
Interactive Grid
Oracle JET
Charts
Universal Theme
Productivity Improvements
Packaged Apps
Calendar
48
6
7Slide49
49New Functionality
Calendar
Inclusive End Date
–
In release 5.0 was exclusive, but now inclusive like other components
JavaScript Customization
–
Support JS code customization of initialization attributes
Dynamic Action Events
–
Capture calendar events and define actions against these events
Keyboard Support
–
Use arrow keys to navigate within the calendar when it has focusSlide50
50Slide51
51Slide52