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

Tips and Tricks – Data Edition

November 13, 2019

ORDS

In ORDS

ORDS TV a la Oracle-BASE

November 4, 2019 1 Min Read

Even more video content for Oracle REST Data Services via the oraclebase YouTube channel.

ORDS

In ORDS

Batch Loading CSV to a TABLE in Oracle Autonomous Database using AUTOREST API

October 25, 2019 6 Mins Read

Batch load your Oracle Autonomous Database TABLEs with ORDS TABLE REST APIs – with no code to write or maintain!

ORDS

Everything you need 2 know about ORDS On Oracle Autonomous

October 17, 2019

SQL Developer

In SQL Developer

Why can’t I open .pkg files?

October 1, 2019 1 Min Read

How to get Oracle SQL Developer to support your PL/SQL files with a .pkg file extension.

SQL Developer

In SQL Developer

SQLcl and the Load (CSV) command

September 30, 2019 2 Mins Read

Quick overview and demo of the LOAD command in Oracle SQLcl for quickly taking CSV and loading as new rows in an Oracle Database table.

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.