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

Oracle SQLDev for VS Code: Webinar & Upcoming Features

April 10, 2024

SQL Developer

In SQL Developer

Oracle SQLcl version 24.1 is now available!

April 3, 2024 2 Mins Read

Oracle SQLcl version 24.1 is now available! Lots of bug fixes, a new command for backgrounding tasks, and HIGHLIGHTING is now on by default.

ORDS

In ORDS

Oracle Database 23 Feature: Returning OLD VALUE via REST

March 15, 2024 3 Mins Read

Hot to build a REST API to update a record in the Oracle Database, using new 23c RETURNING OLD clause – see what the previous and new value are!

SQL Developer

Oracle SQLcl: Easy Command Line access to your Database

March 14, 2024

SQL Developer

In SQL Developer

Adding Custom Snippets in VS Code for SQL Developer

March 6, 2024 4 Mins Read

How to setup your own Code Snippets for Oracle using VS Code along with the Oracle SQL Developer extension – including samples!

SQL Developer

In SQL Developer

Oracle SQLDev extension for VS Code Update, 23.4.1

February 22, 2024 3 Mins Read

Our first update (bug fixes!) is now available for Oracle SQL Developer’s extension for VS Code … version 23.4.1! Here’s a quick overview of what’s been addressed.

SQL Developer

Assign/Change Keyboard Shortcuts in SQL Dev for VS Code

February 20, 2024

SQL Developer

In SQL Developer

Why is my VS Code Extension (SQL Developer) not working?

February 6, 2024 3 Mins Read

Having problems accessing features from the Oracle SQL Developer Extension for VS Code, or even getting them to work? Fix it in just a few clicks!

SQL Developer

In SQL Developer

SQLDev for VS Code: Simple Command Line Integration

February 5, 2024 3 Mins Read

With our new Oracle SQL Developer extension for VS Code, we made sure to also include a FIRST CLASS command line experience!

SQL Developer

Working with objects in your Oracle Database with VS Code

January 29, 2024

SQL Developer

In SQL Developer

Navigating your schemas/databases in SQLDev for VS Code

January 25, 2024 3 Mins Read

A quick look at how to navigate and explore your Oracle Database schemas using Oracle SQL Developer Extension for VS Code.

SQL Developer

In SQL Developer

Go to Declaration vs Peek in SQLDev for VS Code

January 23, 2024 3 Mins Read

How to navigate your Oracle Database from your PL/SQL and SQL code in VS Code using Peek and Go To Declaration features.

SQL Developer

Code Completion in Oracle SQLDev extension for VS Code

January 22, 2024

SQL Developer

In SQL Developer

Logins, TNS, DBMS_OUTPUT, & dates in SQLDev for VS Code

January 19, 2024 2 Mins Read

How to setup Oracle SQL Developer Extension for VS Code to show DBMS_OUTPUT, use the right DATE Format, see your TNSNames.ORA file, and more.

SQL Developer

In SQL Developer

Logging in our VS Code Extension, the code behind the code

January 18, 2024 2 Mins Read

How to get DEBUG info and logs from when something isn’t working in our Oracle SQL Developer Extension for VS Code, including our SQL and PL/SQL code!