You can add a comment, or leave me a question, but I won't be looking or responding to those until Tuesday, the 22nd of October, 2024. Have no fears, I'm alive and well. But my partner and I are taking a holiday to celebrate our 25+ years married (to each other, yes!) If that sounds

ThatJeffSmith

10.10.2024

Oracle SQLDev VS Code Formatter & Task Management

Oracle SQL Developer for VS Code 24.3 is available: new code formatter preferences and a task monitor for watching and cancelling your long running tasks.

ThatJeffSmith

09.10.2024

PL/SQL debugger now available in SQL Developer for VS Code

Oracle SQL Developer Extension for VS Code version 24.3 is here, and so is our support for debugging your Oracle Database PL/SQL programs!

ThatJeffSmith

04.10.2024

TypeScript (Remix) Web app using Oracle Database, REST APIs

We built you a best practices sample web application using the popular Remix framework powered by an Oracle Database and REST APIs. Let's take a look!

ThatJeffSmith

03.10.2024

Oracle SQL Developer & VS Code Primer plus some Tips/Tricks

A collection of thoughts and idea for the Oracle SQL Developer user looking to get started with working with Oracle Database in VS Code.

ThatJeffSmith

02.10.2024

Python Flask w/JavaScript to demo Oracle REST APIs

An example Flask web app that interacts with an Oracle Database, via ORDS REST APIs. You can pull local and build this yourself or use our hosted LiveLabs!

ThatJeffSmith

17.09.2024

How are we (Oracle) doing? Here’s your chance to tell us!

It's that time of year again, where the Oracle Database product and development team are asking for your feedback! This survey will only take a few minutes - we'll read every response!

ThatJeffSmith

13.09.2024

Where is the Code Outline in SQL Developer, for VS Code?

Oracle SQL Developer's extension for VS Code DOES support a code outline for SQL and PL/SQL - here's a quick demo!

ThatJeffSmith

06.09.2024

What’s our vector, Victor? My ‘Hello, World’ demo with beer.

How to load pre-built embedding generation model into Oracle, compute VECTORs, create VECTOR INDEX, and find similar text with the VECTOR_DISTANCE function.

ThatJeffSmith

04.09.2024

23ai ‘trivia’: Domains, Annotations, & Duality Views

You can code more of your data models into your Oracle Database 23ai schemas today using DOMAINs and ANNOTATIONS. Here's an example with a DUALITY VIEW.

ThatJeffSmith

22.08.2024

Querying JSON Relational Duality Views via REST APIs

How to filter or search your Oracle Database 23ai JSON Relational Duality Views using REST APIs, a simple example using our simple dot notation.

ThatJeffSmith

22.08.2024

Python Developers: Learn how to work with JSON in your Oracle Database via REST APIs at Cloud World

App developers, learn how to use REST APIs to get the most out of your Oracle Database with our new Hands On LiveLab at Cloud World 2024

ThatJeffSmith

21.08.2024

Come see the Database Tools team at Oracle Cloud/DB World

What is the Database Tools team up to at Oracle Cloud World 2024? I have our list of sessions, labs, panels, and more here for easy registration.

ThatJeffSmith

06.08.2024

Oracle Database 23ai Free 23.5, now avail for VirtualBox

Oracle Database 23ai FREE has been updated to version 23.5, and that's now available via our VirtualBox Appliance. Also - easier onramp to building APEX apps!

ThatJeffSmith

31.07.2024

Using SQL Developer for VS Code to build Duality Views

An overview of using SQL Developer extension for VS Code to point and click your way through building Oracle 23ai Duality Views.

ThatJeffSmith

30.07.2024

SQL Developer Extension for VS Code 24.2 is now available

Oracle SQL Developer Extension for VS Code update 24.2 is now available! DB 23ai devs now get a rich GUI for working with JSON Relational Duality Views!

ThatJeffSmith

20.07.2024

Let’s build a mini-changeLog for Oracle using SQLcl.

How to build a Liquibase changeLog to create your Oracle tables, load the data, and publish their REST APIs, automatically with SQLcl.

ThatJeffSmith

16.07.2024

ORA-00918: column ambiguously specified, but what column?

Oracle Database 23ai had a primary objective - make the Oracle Database more developer friendly. One of the byproducts of that mission, was more useful error messages, including ORA-00918 & ambiguous column names.

ThatJeffSmith

09.07.2024

Using the Keyboard to connect in SQL Developer for VS Code

Setting up a keyboard shortcut in VS Code and the SQL Developer extension so you can seamlessly connect to your database, without having to touch the mouse.

ThatJeffSmith

09.07.2024

SQLcl 24.2 Quick Hit: Generating AWR Reports

Oracle SQLcl version 24.2 now makes working with Oracle's Automatic Workload Repository (AWR) features as easy as typing A-W-R!

ThatJeffSmith

03.07.2024

Oracle SQLcl 24.2, connection attempts and -thick -thin

A quick note on connecting to Oracle Database with SQLcl 24.2, what happens when there's a problem, or when we find an Oracle Client.

ThatJeffSmith

02.07.2024

Testing a new version of ORDS, without ‘installing’ it

Running the new version of Oracle REST Data Services to test a new feature, like our new HTTP Error response code (570, 571, 572, 574, 577, 578).

ThatJeffSmith

25.06.2024

ORDS installs & upgrades, the TNS edition

We've recently updated our interactive installer for Oracle REST Data Services. Here's a brief look at installing ORDS and testing it once you're done.

ThatJeffSmith

25.06.2024

JSON Relational Duality view & API for an ‘EMPLOYEES’ entity

A bit more information on what our tools and apis support for working with JSON Relational Duality Views in Oracle Database 23ai.

ThatJeffSmith

31.05.2024

Oracle SQL Developer Extension for VS Code 24.1.1 is here!

Oracle SQL Developer's extension for VS Code version 24.1.1 is now available! Export directly to the clipboard, or toggle your plsql spec/body!

ThatJeffSmith

23.05.2024

Searching JSON Arrays with JSON_EXISTS and REST APIs

How to use JSON_EXISTS function in your Oracle Database REST APIs. Hint: use the PASSING clause! Finding movies having 2 common GENRES (from a JSON array)

ThatJeffSmith

22.05.2024

Retrieve DISTINCT list of values from JSON arrays via SQL

In Oracle, how to use SQL to pull a distinct list of values from a JSON column. Hint: use JSON_TABLE.

ThatJeffSmith

22.05.2024

Oracle REST Data Services Installer Improvements for 24.1

A quick look at the interactive installer improvements for Oracle REST Data Services (ORDS) version 24.1 and a reminder to check the logs.

ThatJeffSmith

16.05.2024

On REST APIs and Oracle Database 23ai JSON native types

Moving from 19c to 23ai? Dealing with JSON will get much easier! A few notes on migrating data, & updating your REST APIs. Plus a reminder on Duality Views.

ThatJeffSmith

10.05.2024

New Video: SQL Developer for VS Code Overview & Demo

My YouTube Channel is still alive, barely! I've just uploaded a 20 minute introduction and tutorial for our SQLDev VS Code Extension.

ThatJeffSmith

04.05.2024

Oracle Database 23ai News & an Updated VirtualBox appliance

Here's a roundup of our big Oracle Database 23ai news, including Larry & Juan's video, and our updated VirtualBox appliance so you can play with 23, too!

ThatJeffSmith

02.05.2024

Filtering Objects & Schemas in SQL Developer for VS Code

One of the biggest productivity features added to our latest update for Oracle SQL Developer extension for VS Code (24.1) is the ability to FILTER things.

ThatJeffSmith

01.05.2024

SQL Developer Extension for VS Code v24.1 is now available

Oracle SQL Developer Extension for VS Code version 24.1 is now available on the VS Code Marketplace! Lots of bug fixes and several big new features.

ThatJeffSmith

30.04.2024

Migrating OAuth2 Clients and maintaining their SECRETs

How to move your OAuth2 clients from one Oracle Database to another, maintaining their associated Client Secrets - with our PL/SQL API.

ThatJeffSmith

12.04.2024

Having fun with SQLDev connection names 🚨🚰🌤️

You can give yourself an easy visual reminder of what database connection you're working in, and also make them easier to find 🚀

home›ThatJeffSmith›Software

ThatJeffSmith - Software

Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required

How to cancel a long running Oracle SQL query in VS Code

Another update for our SQL Developer Extension for VS Code

PyTorch to vectorize images, REST APIs to POST to Oracle

Oracle SQL Developer & Data Modeler 24.3 are now available

Temporarily Closed – mr & mrs thatjeffsmith are on holiday

Oracle SQLDev VS Code Formatter & Task Management

PL/SQL debugger now available in SQL Developer for VS Code

TypeScript (Remix) Web app using Oracle Database, REST APIs

Oracle SQL Developer & VS Code Primer plus some Tips/Tricks

Python Flask w/JavaScript to demo Oracle REST APIs

How are we (Oracle) doing? Here’s your chance to tell us!

Where is the Code Outline in SQL Developer, for VS Code?

What’s our vector, Victor? My ‘Hello, World’ demo with beer.

23ai ‘trivia’: Domains, Annotations, & Duality Views

Querying JSON Relational Duality Views via REST APIs

Python Developers: Learn how to work with JSON in your Oracle Database via REST APIs at Cloud World

Come see the Database Tools team at Oracle Cloud/DB World

Oracle Database 23ai Free 23.5, now avail for VirtualBox

Using SQL Developer for VS Code to build Duality Views

SQL Developer Extension for VS Code 24.2 is now available

Let’s build a mini-changeLog for Oracle using SQLcl.

ORA-00918: column ambiguously specified, but what column?

Using the Keyboard to connect in SQL Developer for VS Code

SQLcl 24.2 Quick Hit: Generating AWR Reports

Oracle SQLcl 24.2, connection attempts and -thick -thin

Testing a new version of ORDS, without ‘installing’ it

ORDS installs & upgrades, the TNS edition

JSON Relational Duality view & API for an ‘EMPLOYEES’ entity

Oracle SQL Developer Extension for VS Code 24.1.1 is here!

Searching JSON Arrays with JSON_EXISTS and REST APIs

Retrieve DISTINCT list of values from JSON arrays via SQL

Oracle REST Data Services Installer Improvements for 24.1

On REST APIs and Oracle Database 23ai JSON native types

New Video: SQL Developer for VS Code Overview & Demo

Oracle Database 23ai News & an Updated VirtualBox appliance

Filtering Objects & Schemas in SQL Developer for VS Code

SQL Developer Extension for VS Code v24.1 is now available

Migrating OAuth2 Clients and maintaining their SECRETs

Having fun with SQLDev connection names 🚨🚰🌤️

home
›
ThatJeffSmith
›
Software