The  APEX  -­‐  API   Treasure  Chest March 2016 OGh_nl 2016 Ulrike Brenner Ulrike Brenner • Oracle Developer since 1999 • Oracle DB 8-12c • SQL 
 PL/SQL 
 Oracle Forms/Reports
 APEX • Software-Developer 
 Teamleader 
 Consultant API Application Programming Interface in computer science: 
 a set of routines, protocols and tools for building software and applications
 s n o ti u ol S T I k c cli - k c cli © APEX-APIs • PL/SQL - packages - Directly in APEX in SQL or 
 a PL/SQL-block - Encapsulate in database - packages s n o ti u ol S T I k c cli - k c cli © APEX-APIs Oracle Application Express API Reference is intended for application developers who are building database-centric web applications using Oracle Application Express. s n o ti u ol S T I k c cli - k c cli © APEX-APIs Oracle Application Express API Reference is intended for application developers who are building database-centric web applications using Oracle Application Express. s n o ti u ol S T I k c cli - k c cli © APEX-APIs • Used by APEX itself • Tested • Supported • no need to reinvent the wheel s n o ti u ol S T I k c cli - k c cli © APEX-APIs • APEX 5 (each new APEX-version) - New Features - Deprecated and Desupported Features s n o ti u ol S T I k c cli - k c cli © APEX-APIs • APEX 5
 - 28 packages
 ca. 500 procedures /functions
 - JavaScript APIs • Application Express API Reference:
 https://docs.oracle.com/cd/E59726_01/doc. 50/e39149/toc.htm
 s n o ti u ol S T I k c cli - k c cli © Collections in der DB • Associative Arrays (index-by tables) • Nested Tables • Varrays s n o ti u ol S T I k c cli - k c cli ©