Oracle Database Tips, Tricks, & News for Developers & DBAs

Mostly Making oracle easy, mostly:

SQL Developer

Getting Started with our MCP Server for Oracle Database

Gettings started and deep dive tour of our new MCP Server with Oracle Database! VS Code and Copilot, connect to our db, and run some queries…and more!

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

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.

General

In General

Help Wanted: We’re Hiring!

August 14, 2020 1 Min Read

The Oracle SQL Developer team is looking to hire a developer! If you know your way around an Oracle Database and have experience with Java and web apps, please take a look!

ORDS

In ORDS

SQL Developer Web – Your Favorite Desktop Tricks will Work!

August 11, 2020 2 Mins Read

Because the code is shared amongst our Oracle database tools (SQL Developer, ORDS, SQLcl) – many of the features you love in one tool, work just as expected in the others.

ORDS

REST and the Converged Database

August 10, 2020

SQL Developer

In SQL Developer

Five Simple Tips for SQL Developer

August 5, 2020 4 Mins Read

Yes, yet another Tips & Tricks post for Oracle SQL Developer.

These are the most very basic tips (5) you need to know when getting started with Oracle’s #1 development, query, and administration tool.

SQL Developer

In SQL Developer

Loading Data into Oracle with SQLcl

August 4, 2020 4 Mins Read

A quick walk through of the enhancements for the LOAD command in Oracle SQLcl version 20.2.

ORDS

ORDS and DATES in your TEMPLATEs

July 30, 2020

SQL Developer

In SQL Developer

Oracle SQL Developer Web: Importing JSON as Rows in a Relational Table

July 14, 2020 3 Mins Read

How to import your AVRO, JSON, and XML data into Oracle Database tables using Oracle SQL Developer Web.

ORDS

In ORDS

ORDS 20.2 & the Database Management REST APIs, Updated

July 10, 2020 3 Mins Read

With Oracle REST Data Services version 20.2, you have a TON of new end points available to help manage and monitor your Oracle Database. Here’s a quick tour.