![Page 1: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/1.jpg)
SAGE Computing ServicesConsulting and customised training workshops
Introduction toIntroduction to Oracle Application Express
ODTUGP C kPenny Cookson
Managing Director
www.sagecomputing.com.au
![Page 2: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/2.jpg)
Agenda
ArchitectureBuilding an ApplicationBuilding an ApplicationWhat’s coming in 4.0
www.sagecomputing.com.au
![Page 3: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/3.jpg)
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
![Page 4: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/4.jpg)
Workspaces
Workspace1USER1
Applications
SCHEMA1USER2Pages Shared
Components
Workspace2
SCHEMA2
USER1Workspace2
Shared
Applications
Pages
www.sagecomputing.com.au
SharedComponents
Pages
![Page 5: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/5.jpg)
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
![Page 6: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/6.jpg)
Processing and BranchingProcessing and Branching
Submit PageBranch
Computations
Validation
Computations
Processing
Processing
Session State
![Page 7: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/7.jpg)
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
![Page 8: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/8.jpg)
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
![Page 9: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/9.jpg)
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
![Page 10: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/10.jpg)
What’s Coming in 4.0 –Team Development
AdvisorSearchSearchPlug insFeedbackTodosBugsMilestonesMilestones
www.sagecomputing.com.au
![Page 11: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/11.jpg)
Team Development
• Facilitates the management of the application development process
• Can link directly to APEX Applications and Pages
© 2009 Oracle Corporation
![Page 12: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/12.jpg)
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
![Page 13: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/13.jpg)
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
![Page 14: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/14.jpg)
SAGE Computing ServicesConsulting and customised training workshops
Questions?Q
Presentations are available from our website:www.sagecomputing.com.au
[email protected]@sagecomputing.com.au
![Page 15: Introduction toIntroduction to Oracle Application Express ...€¦ · Application Express but HTMLDB logos V2.1 Application Express V2.2 Application Express 3.0 -> 3.1 -> 3.2 and](https://reader036.vdocuments.us/reader036/viewer/2022081403/60a39d0c7727ea163933239c/html5/thumbnails/15.jpg)
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