Oracle Database Tips, Tricks, & News for Developers & DBAs

Mostly Making oracle easy, mostly:

SQL Developer

Getting Started with our MCP Server for Oracle Database

Gettings started and deep dive tour of our new MCP Server with Oracle Database! VS Code and Copilot, connect to our db, and run some queries…and more!

Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

SQL Developer

Generating DDL for your Oracle objects in SQL Developer Web

January 26, 2023

Database Stuff

In Database Stuff

Hours wasted watching Grey’s Anatomy? Finding out with SQL!

January 23, 2023 7 Mins Read

How to take your personal NETFLIX streaming data and import it to Oracle Database, then use SQL to find out how much time we’ve wasted.

Database Stuff

In Database Stuff

Learning SQL using Spotify II: Functions, Group By, & Dates

January 18, 2023 8 Mins Read

A deeper look at our Spotify streaming data that we’ve imported into our Oracle Database. Here I share a few interesting SQL queries and explain how they work.

Database Stuff

Learning SQL with your own Spotify Streaming History data

January 17, 2023

ORDS

In ORDS

Troubleshooting ORDS startup errors, the pool is invalid.

January 10, 2023 8 Mins Read

Troubleshooting guide for starting up Oracle REST Data Services and invalid connection pools. Bad passwords, user accounts, and more.

ORDS

In ORDS

Create a ORDS REST API in a single PL/SQL call

January 6, 2023 2 Mins Read

Oracle REST Data Services (ORDS) comes with a PL/SQL API you can use to quickly publish a TEST module, aka ‘Hello, World!’

SQL Developer

Physical Properties in Oracle TABLE Liquibase changeSets

January 4, 2023

General

In General

2022 Review & What’s Coming in 2023

January 2, 2023 7 Mins Read

2022 review – A look back on what happened with me in 2022 and what might be happening in 2023 with thatjeffsmith (or, just Jeff).

SQL Developer

In SQL Developer

Run Liquibase updates for a specific schema with SQLcl

December 19, 2022 3 Mins Read

How to run Liquibase updates for a specific schema with Oracle SQLcl. Log in as one user, deploy changeSets to another with your favorite Oracle Database cli.