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

How Paging Works in ORDS..and SQL Developer Web

December 11, 2019

Database Stuff

In Database Stuff

APEX 19.2: Faceted Search

December 4, 2019 4 Mins Read

APEX 19.2 has a very nice new feature for you to play with – Faceted Search!

SQL Developer

In SQL Developer

SQL Developer Web Updates for Oracle Autonomous Database

November 19, 2019 2 Mins Read

Oracle SQL Developer Web version 19.2.1 is now live in your Oracle Autonomous Cloud Services.

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.