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…

SQL Developer

SQL Developer Web: The Keyboard

September 26, 2019

SQL Developer

In SQL Developer

Fixing the ‘My SQL Developer UI is so tiny! Problem

September 19, 2019 2 Mins Read

Making the UI readable in Oracle SQL Developer (using Java 11/12).

SQL Developer

In SQL Developer

ANSI or Oracle Style Joins?

September 10, 2019 1 Min Read

Another quick video demonstration of a new feature in Oracle SQL Developer version 19.2 – we refactor your SQL for you, ANSI or Oracle style JOINS!

SQL Developer

Data Modeler – Define COLS Faster!

September 9, 2019

SQL Developer

In SQL Developer

Oracle Database, SQLcl, & Liquibase: Change Management

September 5, 2019 1 Min Read

Quick overview of new liquibase command plus slides.

ORDS

In ORDS

Some Query Filtering Examples in ORDS

September 3, 2019 2 Mins Read

How to add custom WHERE and ORDER BY clauses to your ORDS GET Handler requests via URL query strings.

ORDS

Oracle VIEWS and REST APIs – Adding a Primary Key

August 27, 2019

ORDS

In ORDS

REST Demo for Oracle Autonomous Database

August 21, 2019 1 Min Read

Overview of REST Services for your Oracle Autonomous Database – slides and video!

Database Stuff

In Database Stuff

2019 Oracle Open World Schedule

August 20, 2019 2 Mins Read

Where you can find me this year at Oracle Open World 2019.

SQL Developer

Using Database Copy to move data to Oracle Autonomous Database

August 9, 2019

ORDS

In ORDS

REST APIs for Oracle Database, updated with ORDS 19.2

August 5, 2019 2 Mins Read

Running Data Pump IMPORT jobs via the ORDS DB API in version 19.2.

SQL Developer

In SQL Developer

Version 19.2 is now available

August 1, 2019 2 Mins Read

Versions 19.2 of EVERYTHING in the Oracle SQL Developer, including ORDS, are now available for download.

SQL Developer

Moving your SQL Developer preferences between machines

July 26, 2019

Database Stuff

In Database Stuff

Performance Hub in Oracle Autonomous Database

July 12, 2019 2 Mins Read

An overview and video demo of the Performance Hub in Oracle Autonomous Database.

SQL Developer

In SQL Developer

All of the Formatting Options for your Query Results

July 10, 2019 1 Min Read

Here are examples of all the options you have for formatting your Oracle Database query results with Oracle SQLcl.