Die  APEX  APIs  Schatzkiste November 2015 DOAG 2015 Ulrike Brenner Ulrike Brenner • Seit 1999 Oracle Entwicklerin • Oracle DB 8-12c • SQL 
 PL/SQL 
 Oracle Forms/Reports
 APEX • Entwicklerin 
 Teamleiterin 
 Kundenbetreuerin API Application Programming Interface 
 Schnittstelle zur Anwendungsprogrammierung
 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 • PL/SQL - Packages - direkt in APEX in einem PL/SQL-Block - in einem Package in der DB gekapselt s n o ti u ol S T I k c cli - k c cli © APEX-APIs • in APEX in Verwendung • getestet • supported s n o ti u ol S T I k c cli - k c cli © APEX-APIs • APEX 5 (jede neue 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 APEX_ Packages
 ca. 500 Prozeduren/Funktionen
 - 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 ©