The recording from our Oracle SQL Developer Extension for VS Code webinar is now available! Plus, here are a few previews of new features about to ship!

ThatJeffSmith

11.04.2024

ORDS version 24.1 is now available, time to upgrade!

Oracle REST Data Services (ORDS) version 24.1 is now available! Here's the release recap and summary of major features and changes you can expect.

ThatJeffSmith

04.04.2024

Oracle SQLcl version 24.1 is now available!

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.

ThatJeffSmith

16.03.2024

Oracle Database 23 Feature: Returning OLD VALUE via REST

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!

ThatJeffSmith

15.03.2024

Oracle SQLcl: Easy Command Line access to your Database

Do you know what's possible at the command line when working with your Oracle Database? Here's a quick reminder of what Oracle SQLcl brings to the table.

ThatJeffSmith

07.03.2024

Adding Custom Snippets in VS Code for SQL Developer

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

ThatJeffSmith

23.02.2024

Oracle SQLDev extension for VS Code Update, 23.4.1

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.

ThatJeffSmith

21.02.2024

Assign/Change Keyboard Shortcuts in SQL Dev for VS Code

How to change the keyboard shortcuts in VS Code for doing things like executing a SQL statement via the SQL Developer extension.

ThatJeffSmith

07.02.2024

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

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!

ThatJeffSmith

06.02.2024

SQLDev for VS Code: Simple Command Line Integration

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

ThatJeffSmith

30.01.2024

Working with objects in your Oracle Database with VS Code

Working with your database objects, including how to manage data in your tables (complete with BLOBs!) using our Oracle SQL Developer Extension for VS Code.

ThatJeffSmith

26.01.2024

Navigating your schemas/databases in SQLDev for VS Code

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

ThatJeffSmith

24.01.2024

Go to Declaration vs Peek in SQLDev for VS Code

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

ThatJeffSmith

23.01.2024

Code Completion in Oracle SQLDev extension for VS Code

A quick overview of what we offer in terms of code completion in Oracle SQL Developer for VS Code and a quick word on Snippets.

ThatJeffSmith

20.01.2024

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

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.

ThatJeffSmith

19.01.2024

How to Import connections from SQL Developer to VS Code

How to import your connections from Oracle SQL Developer to VS Code using SQLcl, it's easy!

ThatJeffSmith

19.01.2024

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

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!

ThatJeffSmith

18.01.2024

Announcing the Oracle SQL Developer Extension for VS Code

The Oracle SQL Developer Extension for VS Code is now available! Here's what you need to know, and some answers to your pressing questions.

ThatJeffSmith

13.01.2024

SQLcl: How to update your connection passwords

How to update the stored password for your saved Oracle Database connections in Oracle SQLcl, your modern command line interface.

ThatJeffSmith

03.01.2024

My favorite posts from 2023 @thatJeffSmith

My favorite posts from 2023, the things I think you might enjoy from the past year.

ThatJeffSmith

21.12.2023

Oracle REST Data Services (ORDS) v23.4 is now available

Oracle REST Data Services (ORDS) version 23.4 is now available for download. This is a maintenance release with more than 300 bug fixes included!

ThatJeffSmith

20.12.2023

Using JavaScript to create test data in Oracle Database 23c

Using SQL Developer Web to create a MLE JavaScript module for generating relational test data in Oracle Database 23c, using Martin Bach's examples.

ThatJeffSmith

16.12.2023

Oracle SQL Developer 23.1.1 is now available

Oracle SQL Developer 23.1.1 is now available with several important bug fixes as well as an updated, embedded Java 11 Home.

ThatJeffSmith

13.12.2023

Can AI generate Oracle Database REST APIs? TL;DR Kinda!?

Can something like ChatGPT write a REST API in 3 seconds to do what I spent hours working on?

ThatJeffSmith

30.11.2023

REST API: Paging results of a PL/SQL REFCURSOR

How to build an Oracle Database REST API that builds paging into browsing the results of a PL/SQL program that returns a REFCURSOR.

ThatJeffSmith

29.11.2023

On relative paths with SQLcl and Liquibase

Yes, you can use relative file paths in your Oracle SQLcl Liquibase AND runOracleScript changeSets. Here's an example with creating a table and loading its data.

ThatJeffSmith

22.11.2023

10 Things you should know about Oracle REST APIs

Here are 10 things I bet you didn't know about REST APIs for your Oracle Database. If you're developing web services, you should read this!

ThatJeffSmith

18.11.2023

How to add custom SQL to your Data Models, TABLE INSERTs

How to insert custom SQL code into your SQL Developer Data Modeler DDL script generated from your data models and designs.

ThatJeffSmith

10.11.2023

REST API: Query Parameter values to a SQL WHERE IN (:list)

How to pull a list of values from a query parameter in your Oracle Database REST API, to use in your SQL WHERE IN (:bind) statement.

ThatJeffSmith

31.10.2023

GraphQL Query Examples with Oracle & ORDS 23.3

Some easy to follow examples querying our Oracle Database using GraphQL, powered by Oracle REST Data Services version 23.3.

ThatJeffSmith

26.10.2023

Using OAuth2 client credentials from a Jupyter Notebook

Using OAUTH2 Client Credentials to retrieve data from an Oracle REST API in your python / jupyter notebook...and how to print emoji characters with json.dumps.

ThatJeffSmith

21.10.2023

ORDS 23.3 is now available or HELLO GRAPHQL!

Oracle REST Data Services 23.3 is now available! One of the biggest new features is the addition of GraphQL support for queries on your Oracle Database!

ThatJeffSmith

21.10.2023

SQLcl Liquibase: Physical Properties for Oracle tables

How to manage physical properties for tables with Oracle SQLcl and Liquibase - suppress things like partitions, compression, and tablespaces.

ThatJeffSmith

13.10.2023

Slides: JavaScript in the Oracle Database Presentation

Presentation slides (optimized for the web!) from my talk on MLE JavaScript in the Oracle Database made easy via SQL Developer Web.

ThatJeffSmith

13.10.2023

How to delete an ORDS Template or Handler…

How to delete your Oracle Database REST API templates or handlers without recreating the entire module, with the ORDS_SERVICE PL/SQL API.

ThatJeffSmith

13.10.2023

Oracle SQLcl 23.3 is now Available for download

Oracle SQLcl 23.3 is now available for download! We've got many new features AND bug fixes to take advantage of, including a new code quality checker.

ThatJeffSmith

19.09.2023

Join me on the EMEA Oracle Community 2023 Tour!

Join us the first week of the EMEA Oracle Community Tour, 2023! I'll be speaking at the Danish, Finnish, and Dutch Oracle User Groups the first week of October

ThatJeffSmith

13.09.2023

cURL vs Python: loading data from a file via Oracle REST API

How to send the contents of a file for the BODY of a POST body REST API in cURL and Python, for Oracle Database to load CSV to a table.

ThatJeffSmith

08.09.2023

ORDS 101: Enabling Oracle Schemas for HTTPS/REST

What does it mean to 'enable your schema' for Oracle REST Data Services (ORDS) in an Oracle Database? Here's how it works and some advice.

home›ThatJeffSmith›Software

ThatJeffSmith - Software

Having fun with SQLDev connection names 🚨🚰🌤️

Oracle SQLDev for VS Code: Webinar & Upcoming Features

ORDS version 24.1 is now available, time to upgrade!

Oracle SQLcl version 24.1 is now available!

Oracle Database 23 Feature: Returning OLD VALUE via REST

Oracle SQLcl: Easy Command Line access to your Database

Adding Custom Snippets in VS Code for SQL Developer

Oracle SQLDev extension for VS Code Update, 23.4.1

Assign/Change Keyboard Shortcuts in SQL Dev for VS Code

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

SQLDev for VS Code: Simple Command Line Integration

Working with objects in your Oracle Database with VS Code

Navigating your schemas/databases in SQLDev for VS Code

Go to Declaration vs Peek in SQLDev for VS Code

Code Completion in Oracle SQLDev extension for VS Code

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

How to Import connections from SQL Developer to VS Code

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

Announcing the Oracle SQL Developer Extension for VS Code

SQLcl: How to update your connection passwords

My favorite posts from 2023 @thatJeffSmith

Oracle REST Data Services (ORDS) v23.4 is now available

Using JavaScript to create test data in Oracle Database 23c

Oracle SQL Developer 23.1.1 is now available

Can AI generate Oracle Database REST APIs? TL;DR Kinda!?

REST API: Paging results of a PL/SQL REFCURSOR

On relative paths with SQLcl and Liquibase

10 Things you should know about Oracle REST APIs

How to add custom SQL to your Data Models, TABLE INSERTs

REST API: Query Parameter values to a SQL WHERE IN (:list)

GraphQL Query Examples with Oracle & ORDS 23.3

Using OAuth2 client credentials from a Jupyter Notebook

ORDS 23.3 is now available or HELLO GRAPHQL!

SQLcl Liquibase: Physical Properties for Oracle tables

Slides: JavaScript in the Oracle Database Presentation

How to delete an ORDS Template or Handler…

Oracle SQLcl 23.3 is now Available for download

Join me on the EMEA Oracle Community 2023 Tour!

cURL vs Python: loading data from a file via Oracle REST API

ORDS 101: Enabling Oracle Schemas for HTTPS/REST

home
›
ThatJeffSmith
›
Software