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

Mostly Making oracle easy, mostly:

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

Sell Me on Oracle SQLcl in 50 Seconds

Why would I use SQLcl…

ORDS

ORDS 22.1.1 – Upgrading using the new CLI and Installer

June 1, 2022

ORDS

In ORDS

The Evolution of ORDS and REST Development Interfaces

May 12, 2022 5 Mins Read

The evolution of Oracle Database REST API development interfaces in SQL Developer, APEX, SQL Developer Web, and SQLcl for ORDS.

SQL Developer

In SQL Developer

SQL Developer Web Tips & Tricks: The Movie!

April 28, 2022 1 Min Read

Nothing but Oracle SQL Developer WEB tips and tricks…the movie! My talk from Oracle Database World, Spring 2022.

ORDS

In ORDS

Building a REST API with ORDS, PL/SQL Functions, & Arrays

April 26, 2022 4 Mins Read

How can I build a REST API for my database that just returns a simple array populated from a SQL SELECT query? Easy, write a few lines of PL/SQL and use ORDS!

ORDS

Oracle REST Data Services version 22.1: Read the README!

April 20, 2022

SQL Developer

In SQL Developer

How to run JavaScript in Oracle SQLcl with Java 17

April 8, 2022 3 Mins Read

How to setup Oracle SQLcl with GraalVM EE with Java 17 to run JavaScript. Full steps for Windows users.

SQL Developer

In SQL Developer

Oracle SQLcl and SQL Performance Warnings

April 7, 2022 2 Mins Read

Oracle SQLcl version 22.1’s new SQL performance code scanning rules, where they came from, and some examples. Find bad SQL before it hits production!

SQL Developer

Oracle SQLcl 22.1 is now available & featuring Data Guard!

April 6, 2022

ORDS

In ORDS

Getting the OpenAPI Specs for your ORDS APIs, 2.0 or 3.0!

April 4, 2022 2 Mins Read

How to get OpenAPI 2.0 vs OpenAPI 3.0 specs on your REST Enabled Objects and REST Modules from Oracle REST Data Services.

ORDS

In ORDS

Using SQL Developer Web to Test POST Handler REST APIs

April 4, 2022 2 Mins Read

How to use the built-in OpenAPI (Swagger) REST client in Oracle REST Data Services to test your POST endpoints for your Oracle Database REST APIs.

ORDS

How To cURL Oracle Database Data Pump Export on Windows

March 29, 2022

SQL Developer

In SQL Developer

Oracle Data Loading Tips & Tricks Video and Slides

March 28, 2022 1 Min Read

Slides and video from our data loading tips and tricks webinar we had with about 135 of our friends.

I do some live demo and share some tips for getting your data imported quickly AND CORRECTLY from CSV or Excel to an Oracle Database.

ORDS

In ORDS

SQL Developer 21.4.3, Data Modeler 21.4.2, ORDS 21.4.3

March 9, 2022 1 Min Read

Release News: Some updates with bug fixes for ORDS, SQL Developer, and SQL Developer Data Modeler Oracle customers. Quick overview and download links.