ORDS, SQLcl, APEX via YUM and DNF

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

ETags and Oracle REST APIs

About this post I explore ETags and how they can be used in cURL commands when interacting with Oracle REST APIs. I also discuss some of the performance benefits of using ETags. This is not exhaustive, but I hope it introduces you to ETags or reminds you of their existence! But first… LATE-BREAKING NEWS!! A … Read more

User Guide: Oracle database in a Podman container, install ORDS locally, and access a SQL Worksheet on localhost

Summary The title says it all. I’ve run through this about ten times now. But I’ll show you how to start a Podman container (with a volume attached) and install ORDS on your local machine. And then, once installed, we’ll create and REST-enable a user so that the user can take full advantage of Oracle … Read more

Oracle Database REST APIs and Apple Automator Folder Actions

The plan was to create an ORACLE REST endpoint and then POST a CSV file to that auto-REST enabled table (you can see how I did that here, in section two of my most recent article). But, instead of doing this manually, I wanted to automate this POST request using Apple’s Automator application… Me…two paragraphs … Read more

Python and the Oracle Autonomous Database: Three Ways to Connect

summary-outut-from-sql-query-in-test1-python-file-chris-hoina-senior-product-manager-ords-oracle-rest-apis-autonomous-database-database-actions

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

Where to learn SQL: a Slack message

What follows is a response I sent via Slack to one of our newest UX Designers. She comes to us by way of another sister business unit within Oracle. She was looking for some resources on where to learn/get better acquainted with SQL (Which for a UX and/or UI designer, I think is a really … Read more

An intro to using Oracle SQLcl on Mac

Did you know you can use Homebrew to install Oracle’s SQLcl on Mac? I just realized this about a week ago (always the bridesmaid, never the bride‚Ķamirite??). Homebrew First you’ll need to install Homebrew (I’m sure there are other ways to install SQLcl, but installing through Homebrew was a breeze). You can install Homebrew on … Read more

Using Python Pandas to turn ISO Country Codes into a string to use as values for a SQL Query

pandas-to_html-printout-of-ISO-codes-table-chris-hoina-senior-product-manager-oracle-rest-apis-oracle-autonomous-database-sql-developer-web-ORDS

Summary, code, resources Problem While querying a table (based on this dataset) with SQL, you realize one of your columns uses 3-character ISO Country Codes. However, some of these 3-character codes aren’t countries but geographical regions or groups of countries, in addition to the actual country codes. How can you filter out rows so you are left … Read more

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

completed-csv-ready-for-oracle-autonomous-database-chris-hoina-senior-product-manager-oracle-rest-apis-database-tools-autonomous-database

That’s right; I’m back again for yet another installment of this ongoing series dedicated to working with Medium.com 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