PL/SQL and the Art of OCI Management

Special guest Robert Pastijn, a member of the Database Platform Technology Solutions group, will share with us how he went about building a set of PL/SQL APIs to help manage Oracle Cloud accounts and services. He initially did this to help the database team manager upwards of 60 different cloud accounts under OCI Classic. Then he upgraded his API to take advantage of APEX_WEB_SERVICE package and apply it to OCI services. These APIs are used in Oracle LiveLabs.

01:46 Introduction and overview
02:50 The backstory: managing 60+ domains for database team
05:36 Making to move to PL/SQL, REST and APEX APIs
06:58 The joy of APEX_WEB_SERVICE, with jokes!
09:09 Using JSON_TABLE to make your JSON data relational
05:40 Quick review of REST
11:05 Encapsulating inside a PL/SQL function, adding screens in APEX
15:12 Downside of OCI Classic REST APIs
16:38 Making the switch from OCI Classic to OCI
19:06 Implementing signing via PL/SQL (and Java)
27:36 Improving signing with DBMS_CLOUD
30:37 Always Free Oracle Cloud reminder
30:58 Summary
33:13 Q & A: Use terraform? Access APIs from C++? And more

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.