application express web application development
TRANSCRIPT
Web Application
Development
Application Express
Agenda
• What is Oracle Application Express
• Demonstration
• Features and benefits
• Customer examples
• Conclusion
• Next steps
• Q&A
Does Your Organization:
• Use spreadsheets as databases?
• Store mission critical data in applications
developed in a desktop database such as
Microsoft Access?
• Not have time to build all of the applications
that users are asking for?
Drawbacks to Desktop Tools
• Fragmented
• Vulnerable
• Platform dependent
• Web unfriendly
• Costly
Oracle Application Express
• Quick assembly of reporting and data entry applications
• Based on existing tables and views or data from spreadsheets
• No programming or scripting
• Instant deployment on the Web
• Use the full power of Oracle
Database 10g
Simplify Application Development
on Oracle
• PL/SQL Developers
• Non-professional developers
• Power users
• Departments
• Small enterprises
D E M O N S T R A T I O N
Rapid Application Development
Oracle Application Express Offers• The Qualities of a Personal Database
• Productivity
• Ease of Use
• Flexibility
• The Qualities of an Enterprise Database
• Security
• Integrity
• Scalability
• Availability
• Portability
• Built for the Web
Consolidation with Application Express
Spreadsheets
Desktop Databases
File ServersAny Browser
Application
Express
Architecture
BrowserOracle Database
Application
Express
Oracle HTTP
Server
How it Works
• Shared Workgroup Database Service
• Centrally Deployed & Managed
• Accessed anywhere via a Browser
• Declarative development style
Oracle Application Express
ApplicationsApplications
ApplicationsApplications
ApplicationsApplications
Logical Architecture
ApplicationsApplications Schema ASchema A
ApplicationsApplications Schema BSchema B
ApplicationsApplications Schema CSchema C
Finance
Human Resources
Marketing
Oracle Application Express
Functionality Overview
• Complete Environment
• Application Builder
• SQL Workshop
• Administration
Application Development
• Reports
• Data entry forms
• Charts
• Security
• Navigation
• Look and feel
Reports
• Pagination
• Column sorting
• Export to spreadsheet or XML
• Calendar and tree
• Template driven
• Drill down to other reports, charts, forms
Data entry forms
• Many built in widgets
• Pop up calendar
• List of values
• Validations
• Lost update detection
• Tabular forms
• Master detail forms
Charts
• Bar, Pie, Line, Dial
• SVG based
• Drill down
• Asynchronous refresh
Security
• Built in authentication modules
• LDAP
• Single Sign-On
• Centrally defined authorization rules
• Session state protection
• Integration with database security features
• FGAC
• Transparent Data Encryption
Navigation
• Tabs
• Lists
• Menus
• Breadcrumbs
Look and feel
• Template driven
• Consistent throughout
application
• Customize with HTML
and CSS
Customer Examples
• Telstra
• PGA of America
• Lansing Community College
- Rosemarie Barr, Director/Corporate Controller of Finance,
Professional Golfers Association of America
“Typically, application development is
completely out of the realm of what
finance departments are capable of doing.
With Oracle HTML DB*, we can now build,
deploy and manage our own web
applications. It's that easy!”
*Oracle HTML DB is now named Oracle Application Express
- Glenn CernyChief Information Officer
Lansing Community College
“Oracle HTML DB has clearly strengthened our
ability to collect and present information via
robust web based applications, with very short
turnarounds and with very high user acceptance.”
*Oracle HTML DB is now named Oracle Application Express
Availability• Release 1.6
• Ships on 10gR2 Companion CD
• Release 2.0• Standalone download from OTN
• Works & Supported in Oracle Database 10g and Oracle Database 9iR2 (9.2.0.3+)
• Included as a component of Standard One, Standard and Enterprise Editions
• No Additional Charge
Conclusion• Improve application development productivity
• Consolidate
• Increase data security
• Improve access
Next Steps
• More information and downloads• otn.oracle.com/apex
• Oracle Application Express 2-Day Developer tutorial book• otn.oracle.com/apex
• Download pre-built applications• apex.oracle.com/studio
• Read tips and tricks• orablogs.com/sergio