APEX
Low-Code and High-Control
Jorge Rimblas
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/1424642/oracle_ace_logo.png)
Jorge Rimblas
Senior APEX Consultant
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/1424642/oracle_ace_logo.png)
- Oracle DB since 1995
- APEX since it was HTMLDB in 2004
- Always involved in web technologies
- jrimblas in OTN Forums
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/1503244/apeks_ace_avatar_x46.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/1689396/9781484204856-sm.jpg)
- Contributor to
"Expert Oracle Application Express, 2nd Edition"
with "Themes & Templates" chapter
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218866/insum_logo_sm.png)
Age: 15 years!
Staff: 80+ employees
68 consultants/developers
2017: Deloitte’s Technology Fast 500 ™
APEX Solutions: 13 Years!
Largest APEX practice in North America
Oracle Center of Excellence
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218031/pasted-from-clipboard.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218034/gold_partner.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218038/odtug.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218041/oaug.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218866/insum_logo_sm.png)
Objective
Oracle
Application Express
APEX
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4538306/apex_logo1.png)
ā'pěks
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4538357/apex_logo1_transparent.png)
Tool for
Web Development
No Cost Option of the Oracle Database
Oracle XE 11g
Oracle 12c EE
.
.
11g R1, 11g R2, 12c
XE, SE, SE2, EE
HTML DB 1.5
First Release 2004
APEX 2.0
Renamed in 2006
APEX 5.1.4
December 2017
Almost 14 years old!
Database Centric
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534398/sql_skills.png)
Leverage SQL Skills and database capabilities
Database Centric
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534395/desktop_and_mobile.png)
Desktop & Mobile Web apps
Database Centric
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534397/visualize.png)
Visualize and maintain DB data
Database Centric
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534395/desktop_and_mobile.png)
Desktop & Mobile Web apps
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534397/visualize.png)
Visualize and maintain DB data
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534398/sql_skills.png)
Leverage SQL Skills and database capabilities
App Development IDE is a web browser
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4534391/Web_IDE.png)
No client software needed
App definitions are stored in the database as meta data
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4536681/apex_metadata.png)
Declarative - No code generation
Page generation is efficient.
Only one request and one response.
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4536690/APEX_page_merge.png)
Data processing done in the DB
Demo
Component Spectrum
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4540883/apex-51-elements.jpg)
Targeted Control
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4540353/create-button.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4540358/save-button.png)
Targeted Control
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4540363/all-conditions.png)
Targeted Control
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/4540672/item-conditions.png)
What's Next?
Code: INSUM for $100 off
Q&A
APEX
Low-Code and High-Control
Jorge Rimblas
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/1424642/oracle_ace_logo.png)
Twitter: @rimblas
![](https://s3.amazonaws.com/media-p.slid.es/uploads/32280/images/2218866/insum_logo_sm.png)
APEX Low-Code and High-Control
By Jorge Rimblas
APEX Low-Code and High-Control
- 2,117