Oracle Database Tips, Tricks, & News for Developers & DBAs - Part 28

Mostly Making oracle easy, mostly:

Getting Started with our MCP Server for Oracle Database

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!

Read More

I’m new to Oracle, and I need a database…help!

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!

Read More

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

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!

Read More

General

My path to being a Product Manager and some advice

April 14, 2020

ORDS

In ORDS

PDB Lifecycle Management Operations via the ORDS DB API

April 6, 2020 5 Mins Read

Using the ORDS DB REST API to clone and drop an Oracle Pluggable Database via HTTP POST.

Database Stuff

In Database Stuff

Oracle Database on YouTube

March 16, 2020 4 Mins Read

Some YouTube videos to catch up on your Oracle Database skills.

SQL Developer

SQL Developer Keyboard Shortcuts: The Movie!

March 12, 2020

ORDS

In ORDS

SQL Developer Web – for 2 or more Databases

February 28, 2020 4 Mins Read

Adding multiple databases for SQL Developer Web in Oracle REST Data Services (ORDS).

SQL Developer

In SQL Developer

SQL Developer 20.1 Preview

February 24, 2020 2 Mins Read

A sneak peek at what the DBTools team is working on for the 20.1 releases of Oracle SQL Developer and Oracle SQL Developer Web.

SQL Developer

SQLDev Quick Tip: Labeling your SQL Query Results

February 14, 2020

ORDS

In ORDS

How to customize OpenAPI Doc for Oracle REST APIs

February 11, 2020 2 Mins Read

How to insert your own MarkDown documentation into your Oracle REST API OpenAPI definitions – great for Swagger tooling!

ORDS

In ORDS

The Curious Case of AUTO REST for a TABLE with an IDENTITY Column

February 7, 2020 2 Mins Read

How to get AUTOREST in Oracle REST Data Services (ORDS) to work with IDENTITY columns

SQL Developer

Quick Tip: Stripping out your Java/Python from your SQL

February 6, 2020

SQL Developer

In SQL Developer

5 Minutes Demo: Using Liquibase in SQLcl to version Oracle Database

February 5, 2020 2 Mins Read

5 minute video demo of Oracle SQLcl and Liquibase to version my Oracle Database plus some updated presentation slides.

ORDS

In ORDS

Updated Slides for our Database Management REST APIs

February 3, 2020 1 Min Read

Updated slides for our Oracle Database management REST APIs – powered by Oracle REST Data Services (ORDS).

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.