Transcript Lilly - UK Oracle User Group

Introduction to Apex
Jon Barwell – Solutions Architect (Celesio Group (UK))
What is Oracle Application Express?
• Oracle’s primary tool for building Web Applications with SQL
and PL/SQL
• Very scalable and secure – a component of the Oracle DB
• Develop Desktop and Mobile applications
• No cost, supported component of the Oracle Database
• 100% Browser-based Development and Runtime
• On premise, on laptop, on cloud, on RAC, any platform Oracle
DB is available on
Apex History
HTML DB 1.5
 First Release
HTML DB 1.6
 Themes
Apex 3.1
Apex 2.1
Apex 2.2




 Packaged Applications
2004
2005
HTML DB 2.0
 SQL Workshop
2006
2007
Apex 3.0
 Flash Charts
 PDF Printing
 Access Migration
2008
Apex 4.2
Apex 4.0
 Interactive
Reports
 Oracle XE
Websheets
Dynamic Actions
Plug-Ins
Team Development
2009
Apex 3.2
 Oracle Forms
to APEX
Conversion
2010
 Mobile
 HTML5
 Packaged Apps
2011
Apex 4.1
 Data Upload
 Error Handling
 ROWID
2012
2013
2014
2015
Apex 5.0
 Page Designer
 Universal Theme
Architecture
Oracle Database (10g onwards)
SE1, SE, EE (also XE)
Web Server Architecture Variants
Oracle REST Data Services
– J2EE based alternative to Oracle HTTP Server
– Certified Application Servers – Glassfish, WebLogic, Tomcat
Requirements
• Costs
– Oracle Database Licence
– Application Server (optional)
• Skills
–
–
–
–
–
–
Database Design (Essential)
Oracle Database Concepts (Essential)
SQL (Mandatory)
PLSQL (Optional)
Javascript (Optional)
HTML & CSS (Optional)
• HTML5
• CSS3
– Apex Application Builder (Essential)
Demo
Design Guidelines
• Use the declarative features of APEX as much as possible,
don't write code.
• When you need to venture outside the declarative features of
APEX and you need to write code in PL/SQL, be smart about
it.
• Avoid huge sections of JavaScript and use Dynamic Actions
wherever possible.
• APEX is just a thin veneer over your database - architect your
APEX applications as such.
Joel Kallman – Director of Software Development (Apex)
When Should I Use Apex?
•
•
•
•
•
•
•
Bespoke Application Development
Rapid and Agile Development
Graphical representation of data (Charts)
Extend Oracle E-Business Suite functionality
Oracle Discoverer Replacement
Cost effective Business Intelligence
Access remote data sources and Services using Oracle REST
Data Services
• Oracle Forms & Reports - complement/replacement
Additional Features of Apex Environment
• SQL Workshop
• Team Development
• Packaged Applications