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

Excel/CSV Import to a new TABLE in SQL Developer Web

January 27, 2020

ORDS

In ORDS

ORDS Frequently Asked Questions

January 16, 2020 5 Mins Read

Your frequently asked questions for Oracle REST Data Services (ORDS).

ORDS

In ORDS

Performance Hub and SQL Developer Web

January 9, 2020 2 Mins Read

Using the Performance Hub in Oracle SQL Developer Web. Includes a quick animated GIF demo.

SQL Developer

Protect your data with Encrypted Data Pump Jobs

January 6, 2020

ORDS

In ORDS

REST Enable Schema Aliases and SQL Developer Web

January 3, 2020 4 Mins Read

How to login into your Oracle Database with SQL Developer (Database Actions) when your schema is REST enabled with a schema alias.

ORDS

In ORDS

SQL Developer Web is now Available

December 23, 2019 4 Mins Read

Oracle SQL Developer Web (and everything else) is now available!

ORDS

In ORDS

How Paging Works in ORDS..and SQL Developer Web

December 11, 2019 4 Mins Read

How does Oracle REST Data Services (ORDS) page the results of your SQL based RESTful Services? Plus a quick warning about using CURSORs in your SQL.

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

Tips and Tricks – Data Edition

November 13, 2019 1 Min Read

30 minutes of tips and tricks using Oracle SQL Developer, and they’re all about working with your Oracle Database data!

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

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

October 25, 2019

ORDS

In ORDS

Everything you need 2 know about ORDS On Oracle Autonomous

October 17, 2019 3 Mins Read

Everything you need to know for building REST APIs for your Oracle Autonomous Database in the Oracle Cloud.

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.