Setting up SSH to GitHub git clone into your Oracle Cloud Linux Ubuntu VM with VNC

I’m trying to be as succinct as possible. I just accomplished this but couldn’t find anything that explicitly walked me through how to do it. Here are some assumptions: REMINDER: You are signed in to a Linux machine! The commands you will follow (in GitHub or here) WILL NEED TO BE FOR LINUX! What happened? … Read more

Python script to retrieve objects from Oracle Cloud Bucket

For…reasons, I needed a way to retrieve all the .CSV files in a regional bucket in Oracle Cloud Object Storage, located at this address: You can visit it; we use it for one of our LiveLabs (this one), so I’m sure it will stay live for a while ๐Ÿ˜˜. Once there, you’ll see all … Read more

Create a view from a JSON Collection and REST-enable it with ORDS

The DBMS_CLOUD PL/SQL Package You can use this PL/SQL procedure (in the DBMS_CLOUD package) along with the file_uri_list URL (seen in the code below) to create and then add JSON documents to a JSON Collection (good info on JSON Collections in the Oracle database). In this example, we call this collection Movie_Collection. ๐Ÿ‘†๐Ÿป This is … Read more


TL;DR BREAKING NEWS!! APEX packages with ORDS and SQLcl now available in Oracle Linux YUM servers and through ULN The deets Here is what you need to know. We are releasing three new APEX (a.k.a. “The Artist formerly known as Oracle Application Express”) packages for the following repositories: NoARCH RPMs One more update! These RPMs … Read more

Python and the Oracle Autonomous Database: Three Ways to Connect


Watch the deep dive videos: Part I Part II Part III Welcome back I finally had a break in my PM duties to share a small afternoon project [I started a few weeks ago]. I challenged myself to a brief Python coding exercise. I wanted to develop some code that allowed me to connect to … Read more

More fun with Medium story stats, JSON, Python, Pandas, and Oracle SQL Developer Web


That’s right; I’m back again for yet another installment of this ongoing series dedicated to working with story stats. I first introduced this topic in a previous post. Maybe you saw it. If not, you can find it here. Recap My end goal was to gather all story stats from my Medium account and … Read more

Oracle REST APIs: A LiveLabs review


Recently Jeff and I were invited by the Oracle Developers and Developer Relations teams to do a walkthrough of a LiveLabs workshop, โ€œHow to Build Powerful and Secure REST APIs for Your Oracle Autonomous Database.โ€ We spent about 90 minutes moving through selected labs in the workshop. Luckily they recorded it for us; you can … Read more

Python + Folium + Oracle REST APIs (aka ORDS)


Willkommen I stumbled upon a new [to me] python library called Folium. It’s a mapping tool that enables python developers (or is it programmers, which is less offensive?) to visualize data on a Leaflet map. About folium Folium makes it easy to visualize data thatโ€™s been manipulated in Python on an interactive leaflet map. It … Read more

Add Primary and Foreign Keys to your Oracle Autonomous Database


I’m not a Database Administrator, but I feel as though I may be slowly evolving into one… In a previous post, I left myself the task of correcting the html on a proposed Python/Flask/ORDS/Autonomous Database application. My then next step was to add a search bar (which I did): Although this was a small step … Read more