New Features ltNamegt ltTitlegt ltOrganizationgt ltDategt Oracle Confidential InternalRestrictedHighly Restricted 3 Agenda 1 2 3 4 5 Oracle Application Express Overview ID: 165389
Download Presentation The PPT/PDF document "Oracle Application Express 5" 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 5New Features
<Name><Title><Organization><Date>Slide3
Oracle Confidential – Internal/Restricted/Highly Restricted3Slide4
Agenda
12
3
4
5
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted
4
6Slide5
1
2
3
4
5
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile
Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted
5
6Slide6
Oracle Application ExpressDatabase-centric web application
development framework
Develop desktop and mobile web apps
Visualize and maintain
database data
Leverage SQL Skills and database capabilitiesSlide7
Oracle Application ExpressDistinguishing Characteristics
App Development IDE is a web browser. No client software neededApp 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 DatabaseSlide8
Oracle Application ExpressDevelop faster, release more frequentlyGo from prototype to production in minutes
Develop
Customize
DeliverSlide9
Oracle Application ExpressUse Cases
Developing opportunistic & self service web apps
Extending enterprise application solutions
Migrating file based and client server apps to the webSlide10
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
Schema and PDB services 5, 20, 50 GB
D
edicated 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 DatabaseSlide11
History
HTML DB 1.5
First
Release
HTML DB
1.6
Themes
2004
2007
2012-14
APEX 2.1
Oracle XE
APEX 2.2
Packaged Applications
APEX 3.1
Interactive
Reports
HTML DB 2.0
SQL
Workshop
APEX
3.0
Flash Charts
PDF Printing
Access
Migration
APEX 3.2
Oracle
Forms
to APEX Conversion
APEX 4.1
Data Upload
Error Handling
ROWID
2006
2009
2011
2008
2005
APEX
4.2.x
Mobile
HTML5
Packaged Apps
APEX 4.0
Websheets
Dynamic Actions
Plug
-
Ins
Team
Development
2010
APEX
5.0
Page Designer
Universal Theme
Modal Dialogs
2015
Also known as Oracle APEX (
āʹpěks
)Slide12
Oracle Application
Express3 Tier Architecture
Browser
Mid Tier
Database Tier
Web Logic Server
WLS
ORDS
Apache
OHS
Oracle APEX
Oracle
Database
SchemasSlide13
Oracle Application Express (APEX 5)~ 400,000 developersBased
on developer downloads, support tickets, check for updates dataConsulting companies, hosting companies, books, applications, success stories and quotes: http://apex.oracle.com/community75+ active
bloggers:
http
://www.odtug.com/
apex
Very active
Forum:
https
://community.oracle.com/community/database/developer-tools/application_express
#ORCLAPEX
Development Community; Very involved, enthusiastic worldwide communitySlide14
Books Slide15
Useful LinksOracle Technology Network http://otn.oracle.com/apex
APEX Community http://apex.oracle.com/communityOracle 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 ServicesSlide16
1
3
4
5
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile
Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted16
6
2
AgendaSlide17
Page DesignerMultiple trees to view the page componentsVisualization of the page within the Grid Layout, and associated Gallery, allowing you to drag and drop componentsUpdate multiple attributes without leaving the page in the Property Editor Highly configurable user interface: Customize and refine view of page specific to current focus
Slideable panelsHide / show groupingsPowerful browser-based IDESlide18Slide19
Code EditorSyntax HighlightingUndo / RedoFind/ReplaceAuto completionCode validationUsed in Page Designer, Component View and
SQL WorkshopAvailable for maintaining SQL, PL/SQL, JavaScript, HTML, CSS, and large text sectionsSlide20
1
3
4
5
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted
20
6
2
AgendaSlide21
Redesigned APEX User InterfaceComplete redesign of APEX UI templates, using HTML5 and grid layoutNew artwork – replacing CSS sprites with SVG based vector graphics Using icon fonts for most smaller icons in Page Designer, menu bars and buttons
Oracle Confidential – Internal/Restricted/Highly Restricted21Modern HTML5 UI Slide22
Universal ThemeNew default theme for APEX applicationsUses responsive HTML5 templatesGrid-layout for HTML formsModern flat-lookShips with a variety of pre-built theme stylesOlder themes still available as legacy themes, and will remain part of the product for backwards compatibility
OverviewSlide23
Universal ThemeDeclarative CSS modifiers for HTML5 templatesEnables developers to declaratively apply styles like borders, padding, icons, colors, size, etc.
Uses easy-to-understand, descriptive namesAvailable for most template types:Page, Region, Report, Breadcrumb, List, Item, ButtonSignificantly reduces the number of required templates for a theme
Template OptionsSlide24
Universal ThemeTheme Styles provide a variety of different color schemes and styles for a single themeDefined as CSS file that is included in addition to the theme’s base CSS fileUniversal Theme includes several pre-built stylesAdditional styles can be easily generated using the built-in Theme Roller utility
Theme Styles and Theme RollerSlide25
Universal ThemeAlternative to using traditional tabsAvailable as top navigation menu and side menuImplemented as standard APEX listsSupports multi-level hierarchical menu structuresProvides accessible pull-down menusType of navigation determined by themes – Universal Theme uses listsMigration of older one-level tabs to lists when switching themes
Oracle Confidential – Internal/Restricted/Highly Restricted25
List-based navigationSlide26
Universal ThemeExtends existing templates subscription modelSubscribes all templates and template options to a master themeTemplates are read-only in subscribing themesTemplates can be copied within a theme – local copies are editableWhen creating new applications, themes are subscribed to the base theme by default
Ensures upgradeability of included base-themes in the futureOracle Confidential – Internal/Restricted/Highly Restricted26
Theme subscriptionsSlide27
1
3
4
5
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile
Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted27
6
2
AgendaSlide28
Mobile DevelopmentDeclarative support for building mobile web applications APEX Applications support multiple user interfaces:
Desktop and Smartphone; Desktop only; or just MobileMobile pages use jQuery Mobile through ajQuery Mobile based theme and templatesMobile Pages are lighter weight than Desktop PagesCan respond to touch-based eventsHTML5 charts and HTML5 item typesRapidly build Web-based Mobile ApplicationsSlide29
Navigation Menus and Slide Panels
All top level pages added to Navigation ListNavigation lists in Mobile apps are implemented as menu panelsShown on the left with menu button shown in top barCustom panels using “Panel” region templateChoice of display modes: Overlay, Reveal, Pushdata-role="panel"Slide30
Column Toggle ReportSelectively hides columns at narrower widths as a sensible default Offers a menu to let users manually control
which columns they want to seeColumn Toggle Popup contains a dynamically generated list of columns based on the table markupDevelopers can set column priorities (1 – 6) Slide31
Reflow Table ReportCollapsing table data into label/data pairs for each rowStacked presentation style defaultMedia query used to switch to tabular style
presentation above a specific screen widthOracle Confidential – Internal/Restricted/Highly Restricted
31Slide32
Mobile CalendarNew Calendar Region type for Desktop and MobileMonthly-, Weekly-, Daily- and List ViewSupports touch eventsCustomization through CSSSlide33
1
3
4
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile
Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted33
2
Agenda
5
6Slide34
Modal DialogsOracle Confidential – Internal/Restricted/Highly Restricted34
Replacement for Popup WindowsA modal dialog is a stand-alone page, not a region on a pageAny page be created as a dialog pageSupports all the functionality of a regular page, incl. computations, validations, processes, and branchesSlide35
Interactive Report EnhancementsCreate multiple Interactive Reports on a single pageModal dialogs replace “push-down” dialogs that were previously used for filters, formatting, save, export, etc.New HTML5 HTML structure – lighter weight and accessibleFrozen filter-bar stays in place when scrolling
Oracle Confidential – Internal/Restricted/Highly Restricted35
Multiple IRRs & UI EnhancementsSlide36
Interactive Report EnhancementsEasy creation of pivot reports on existing dataSelect one or more columns as pivot columns and one or more columns as the row columnsApply aggregation functions to columns, assign labels and format masks
Oracle Confidential – Internal/Restricted/Highly Restricted36
Pivot ReportsSlide37
New CalendarNew calendar region typeBased on Full Calendar jQuery Plug-InProvides full-size calendar with monthly, weekly, daily and list viewSupport duration based events with start and end dateDrag & drop capabilities allow for rescheduling of events
Customization of look & feel through CSSOracle Confidential – Internal/Restricted/Highly Restricted37Slide38
Static files / Relative URL referencesUpload application and workspace images into databaseSupports relative file URL referencesZIP files automatically unzipped and placed in folder structureSupports versioning / CachingCan be used to store theme style CSS files and include in export
Oracle Confidential – Internal/Restricted/Highly Restricted38Slide39
1
3
4
Oracle Application Express Overview
Page Designer
User Interface and Universal Theme
Mobile
Enhancements
Functional Improvements
Security Enhancements
Oracle Confidential – Internal/Restricted/Highly Restricted39
2
Agenda
5
6Slide40
Browser Security OptionsBrowser Cache: prevent back button from showing old page content after logout (APEX 4.1)Embed in Frames: prevent other apps from embedding and remote controlling your application
(APEX 4.1)Define custom HTTP headers at instance and application level (APEX 5.0)Slide41
Authentication and AuthorizationFlexible authentication - change the authentication of the development environment itself - LDAP, SSO, HTTP Header Variable, etc. (APEX 5.0)
Authorizations and conditions for on demand processes (APEX 4.2)
Assign workspace groups to other groups (APEX 5.0)
Set group membership for session on login, including external groups
(APEX 5.0)
Is In Group authorization (APEX 5.0)Slide42
Improvements to avoid Cross-Site Scripting (XSS)HTML Expression attribute for report columns with substitution support instead of concatenating strings in the query (APEX 4.1)Restricted Characters attribute for items rejects malicious input (APEX 4.2)More restrictive HTML-Escaping and APEX_ESCAPE API
(APEX 4.2)New escaping syntax, e.g. &P1_ITEM!JS. for fine grained control (APEX 5.0)Slide43
Instance Lockdown and Workspace IsolationLimit emails (APEX 4.1)Resource manager support (APEX 4.2)Limit file uploads (APEX 5.0)Limit
debug output (APEX 5.0)Limit concurrent requests per session and per workspace (APEX 5.0)Limit workspace access by hostname (APEX 5.0)Slide44
Cryptography ImprovementsStronger session cookie (APEX 4.2)SH-1/SH-2 for checksums (APEX 5.0)Improved hashing algorithm for workspace user passwords (APEX 5.0
)New applications/forms are checksum protected by default (APEX 5.0)Support DB 12c DBFIPS_140 mode (APEX 5.0)DBFIPS_140 enables Transparent Data Encryption (TDE) and DBMS_CRYPTO PL/SQL package program units to run in a mode compliant to the Federal Information Processing Standard ("FIPS mode”)Slide45
SummaryOracle Application ExpressSlide46
Oracle Application ExpressUsed 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 over 10 years ago
Continually growing
:
Oracle install base is adopting Oracle APEX for increasing numbers of projects, and is increasingly an approved corporate IT standard
.
SummarySlide47
Oracle Application ExpressAligned with industry trends: Strong support for HTML5 development frameworks,
Modern & responsive CSS3 UI, integrated JavaScript 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
.
SummarySlide48Slide49
Oracle Confidential – Internal/Restricted/Highly Restricted49Slide50