/
Oracle Application Express 5 Oracle Application Express 5

Oracle Application Express 5 - PowerPoint Presentation

tatiana-dople
tatiana-dople . @tatiana-dople
Follow
437 views
Uploaded On 2015-10-19

Oracle Application Express 5 - PPT Presentation

New Features ltNamegt ltTitlegt ltOrganizationgt ltDategt Oracle Confidential InternalRestrictedHighly Restricted 3 Agenda 1 2 3 4 5 Oracle Application Express Overview ID: 165389

apex oracle application restricted oracle apex restricted application highly express theme internal confidential page universal http database based enhancements

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

Slide1
Slide2

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 IDESlide18
Slide19

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

.

SummarySlide48
Slide49

Oracle Confidential – Internal/Restricted/Highly Restricted49Slide50