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

Building a RESTful Web Service using SQL Developer Web (PUT)

November 16, 2020

ORDS

In ORDS

SQL Developer Web: Building RESTful Web Services

November 13, 2020 3 Mins Read

Quick overview of the new REST Development Interface in Oracle SQL Developer Web – powered by ORDS version 20.3.

SQL Developer

In SQL Developer

Working with {JSON} in SQL Developer Web

November 2, 2020 4 Mins Read

Working with JSON in the database just got that much easier with SQL Developer Web version 20.3!

SQL Developer

Oracle SQLcl supports your Oracle Cloud (OCI) APIs

October 30, 2020

ORDS

In ORDS

ORDS, SQLcl, Data Modeler 20.3

October 29, 2020 2 Mins Read

Oracle REST Data Services and SQLcl version 20.3 are now available!

Database Stuff

In Database Stuff

My Conversation with Jim Grisanzio

October 22, 2020 1 Min Read

My interview with Jim Grisanzio for the Groundbreakers Asia Pacific (APAC) Virtual Tour 2020.

ORDS

ORDS Example: Many Tables and a Parameter

October 20, 2020

ORDS

In ORDS

Fastest Way to Upload a bunch of Documents to your Oracle JSON Collection?

October 16, 2020 3 Mins Read

How to quickly load a bunch of documents to my JSON Collection in a single REST call using Oracle Database and ORDS.

SQL Developer

In SQL Developer

Video: Working with Problematic SQL in Oracle Autonomous Database

October 13, 2020 1 Min Read

A video tour of finding and dealing with your problematic SQL in Oracle Autonomous Database using Oracle SQL Developer

SQL Developer

Useful Features in SQL Developer Web…that you might be overlooking!

October 8, 2020

SQL Developer

In SQL Developer

DBA Masterclass, Week 1: Data Modeling

September 22, 2020 7 Mins Read

Questions AND answers from today’s masterclass series on Data Modeling for DBAs – using Oracle SQL Developer Data Modeler.

SQL Developer

In SQL Developer

Creating Oracle Connections…from outside of SQL Developer

September 1, 2020 4 Mins Read

How to launch Oracle SQL Developer connections from the command line.

SQL Developer

Exploring the latest SQL Developer Web in the Oracle Autonomous Database

August 28, 2020

SQL Developer

In SQL Developer

Changing the User Interface Language in Oracle SQLcl

August 25, 2020 3 Mins Read

How to set JVM flags or change the user interface language for Oracle SQLcl.

SQL Developer

In SQL Developer

It’s 2020, and SQL Injection is STILL a Serious Problem

August 25, 2020 3 Mins Read

Detecting SQL injection in your PL/SQL with Oracle SQLcl, your modern command line interface for the Oracle Database.