introduction tointroduction to oracle application express ...€¦ · application express but...

SAGE Computing ServicesConsulting and customised training workshops

Introduction toIntroduction to Oracle Application Express

ODTUGP C kPenny Cookson

Managing Director

www.sagecomputing.com.au

Agenda

ArchitectureBuilding an ApplicationBuilding an ApplicationWhat’s coming in 4.0

www.sagecomputing.com.au

Overview

HistoryProject MarvelProject MarvelHTMLDB V1.5, V1.6Application Express but HTMLDB logos V2.1Application Express V2.2Application Express 3.0 -> 3.1 -> 3.2 and ?4.0

Included in Oracle Express Edition Small /medium systems developmentDeclarative approachBrowser based developmentPL/SQL, HTML, JavaScript skills

www.sagecomputing.com.au

Workspaces

Workspace1USER1

Applications

SCHEMA1USER2Pages Shared

Components

Workspace2

SCHEMA2

USER1Workspace2

Shared

Applications

Pages

www.sagecomputing.com.au

SharedComponents

Pages

Overview – Page Definition

Page Rendering Page Processing

On Load Regions Buttons Items

On Load Processes Computations

ValidationsItems

Computations ProcessesBranching

Tabs Lists of Values Themes Templates Navigation Bars Web Services

www.sagecomputing.com.auShared Components

Processing and BranchingProcessing and Branching

Submit PageBranch

Computations

Validation

Computations

Processing

Processing

Session State

What’s Wrong With 3.2

Too much work to make it cute Poor for team developmentPoor for team developmentTabular forms are horrible

www.sagecomputing.com.au

Improved Application Builder

• New look• Improved navigation

I d Ad i i t ti• Improved Administration screens

• IR’s everywhereIR s everywhere• Integrated ‘Advisor’ and

‘Application Search’

© 2009 Oracle Corporation

What’s Coming in 4.0 – UI

ItemsResizeable text areasResizeable text areasCombo boxAutocompleteAutocompleteLess types, more attributes

D l i l d fi li b h i (Declaratively define client behaviour (e.g. validation, actions )Improved themesIntegrated jQuery and jQuery UIg jQ y jQ yWebsheets

www.sagecomputing.com.au

What’s Coming in 4.0 –Team Development

AdvisorSearchSearchPlug insFeedbackTodosBugsMilestonesMilestones

www.sagecomputing.com.au

Team Development

• Facilitates the management of the application development process

• Can link directly to APEX Applications and Pages

© 2009 Oracle Corporation

Team Development - Built-In Feedback

• Integrated into APEX Applications

• Automatically saves session state

F db k d• Feedback managed in Team Development

• Easily transformed• Easily transformed into Features, To-Dos or Bugs

© 2009 Oracle Corporation

What’s Coming in 4.0 – Other

J2EE-based alternative to mod plsqlDeclarative Tabular FormsDeclarative Tabular FormsIntegrated Oracle EBS AuthenticationUI Defaults with bi directional synchronizationUI Defaults with bi-directional synchronizationImproved Error handlingI d hImproved graphs

www.sagecomputing.com.au

SAGE Computing ServicesConsulting and customised training workshops

Questions?Q

Presentations are available from our website:www.sagecomputing.com.au

enquiries@sagecomputing.com.aupenny@sagecomputing.com.au

SAGE Computing Services(Unrepentant Marketing)

Register for the Next

Application Express V3.2 course:23rd 24th and 26th November23 ,24 and 26 November

Advanced course:8th – 9th December