Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

September 08

14:00 UTC   Start Times Around the World

Description

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

Subscribe to give us feedback and be notified of upcoming sessions!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Robert Pastijn
Robert Pastijn, Senior Principal Technologist (Product Manager/Strategy ProdDev)    
Working with Oracle since 1996 and working for Oracle since 2000, Robert has always focused on the Database and the underlying operating system and hardware. He installed one of the first RAC clusters on 9i, deployed the first Exadata in the Netherlands, and now helps customers and partners through online trainings and on-site workshops.
Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.