iiinova — where your digital self keeps evolving

Jeff Smith @thatjeffsmith.com · 01/07/2026

This dog has some pep left yet!

Jeff Smith @thatjeffsmith.com · 22/01/2026

Hey Claude go build me a model for supporting a credit card business, stick it in my Oracle Database and then populate it with real looking test data. 15 minutes later... thanks MCP!

relational diagram showing tables and how they are related to one another alongside a look at once of those tables (CREDIT_CARDS) and some of the sample data my AI generated for me - in my Oracle Database, as shown in SQL Developer extension for VS Code.

140

Jeff Smith @thatjeffsmith.com · 31/12/2025

Good morning from the east cost

000

Jeff Smith @thatjeffsmith.com · 19/11/2025

I guess it's time i start pretending to be a youtuber, again

1100

Jeff Smith @thatjeffsmith.com · 17/11/2025

it's there for the install adb path ords install adb --help and the interactive gives you the ability to specify if you want we can also read in the passwords from a file, as shown officially in Docs non-interactive, supply pwd => docs.oracle.com/en/database/... (2.1.4.3)

100

Jeff Smith @thatjeffsmith.com · 07/11/2025

remember, the purpose of this resource is for folks learning sql, how to build apps/use oracle db - not for the aspiring dba pretend you are a dba, and a fresher/intern asked for an account on one of your databases, what privs would you give them? We probably have given you more.

120

Jeff Smith @thatjeffsmith.com · 06/11/2025

That's means its approximately 10x easier/faster today than it was yesterday to get started using/learning Oracle, databases, sql, and in general, data management.

041

Jeff Smith @thatjeffsmith.com · 19/09/2025

Asked and answered, can i have a KB shortcut for 'goto declaration' in VS Code (and our SQL Developer extension), YES Easily navigate to dictionary objects from your pl/sql or sql code, mouse or no mouse your choice. #oracle #database

VS Code preferences, keyboard shortcuts, assigning a keyboard sequence to activate 'Go to Declaration'

000

Jeff Smith @thatjeffsmith.com · 09/09/2025

Clicking the 'edit in settings' hyperlinked text takes me to Settings with this filter/search applied "sqldeveloper.connections.tnsConfiguration.path"

000

Jeff Smith @thatjeffsmith.com · 17/08/2025

How did this only sell 6 million copies?

300

Jeff Smith @thatjeffsmith.com · 16/07/2025

Official announcement/introduction to our MCP Server for Oracle Database blogs.oracle.com/database/pos...

11010

Jeff Smith @thatjeffsmith.com · 10/07/2025

Agent mode upgraded with an MCP Server for Oracle Database, yes please! oracle.com/sqlcl

020

Jeff Smith @thatjeffsmith.com · 10/07/2025

Claude is smart enough to know I didn't run that many miles, so it did some maths based on the elapsed time per run I had recorded in my oracle database table, and decided (CORRECTLY) that Strava uses METERS And i just told it to look in my fun database and figure out how many miles I've ran...

170

Jeff Smith @thatjeffsmith.com · 08/07/2025

In 3 hours @krisrice.io and I will brief you on what we've been working on and released yesterday... Sign-up here go.oracle.com/LP=148902?el... The LLMs are good at answering your questions, but also adding context, finding things I might miss. An MCP Server for the Oracle Database.

Using SQLcl's MCP Server for Oracle Database, I asked my AI agent to i "to use my fun connection and tell me what my favorite beer was"

it did the following to answer my question:
0 - asked for permission to use the SQLcl Tools
1 - grabbed list of connections
2 - got permission to use FUN connection
3 - queried to get list of tables in my schema
4 - recognized UNTAPPD
5 - used DESC to confirm it was what it thought it was
6 - queried all 5 star reviews by me
7 - did so again but with a count(*) aggregate
8 - answered my question, and then some

050

Jeff Smith @thatjeffsmith.com · 07/07/2025

we have an official MCP Server for Oracle Database as of...today

1217

Jeff Smith @thatjeffsmith.com · 26/06/2025

I don't only buy things on Insta for myself, I also spoil my teenagers.

blue t-shirt with "I'll just have the chicken tenders"

010

Jeff Smith @thatjeffsmith.com · 05/06/2025

Terminal (CLI) life can be pleasant, if not enjoyable! #Oracle gives you what you need, and then some.

151

Jeff Smith @thatjeffsmith.com · 03/06/2025

Will get Search sorted, and the typo You can share, there's an EZ Code to the right on each page

210

Jeff Smith @thatjeffsmith.com · 09/05/2025

Do you like this @vscode.dev debugger option?

040

Jeff Smith @thatjeffsmith.com · 26/04/2025

Someone at my gym must be the happiest man alive

130

Jeff Smith @thatjeffsmith.com · 16/04/2025

Updated my Getting Started tutorial! Story link in thread.

VS Code setting - Workbench > Tree: Expand Mode.

Animated GIF showing if you set this from single to doubleClick you can can now select a connection in our database connection tree, without opening the database.

220

Jeff Smith @thatjeffsmith.com · 26/03/2025

Did you know? You can search the contents of your Oracle Database, directly from our Oracle Cloud Infrastructure console? A free offering found under Developer Services! Learn more: www.thatjeffsmith.com/archive/2025...

Oracle Cloud Infrastructure (OCI) Console page showing the Database Tools (Developer Services) interface for searching the contents of your Oracle Database.

150

Jeff Smith @thatjeffsmith.com · 16/03/2025

Had to refrain from picking up more at the flea market this weekend.

030

Jeff Smith @thatjeffsmith.com · 13/03/2025

Want to play with Domains, Annotations, and JSON Relational Duality Views, and multi-row INSERTs but you don't have a 23ai database? That's ok, you can borrow ours! Visit livesql.oracle.com and try the SQL code I'm sharing in the follow-up comment to this thread. #json #data #model #SQL

Oracle Database 23ai and building a Relational Duality View with domains and annotations.

121

Jeff Smith @thatjeffsmith.com · 06/03/2025

Having a play with an oldie but goodie Oracle SQL feature, SELECT APPROX_COUNT_DISTINCT as demonstrated by our database pm Killian. Follow along www.killiansbytes.com/post/fast-co... Try it for free livesql.oracle.com/next Hint: limit rows from 10m to 500

Using Oracle Database SQL function APPROX_COUNT_DISTINCT to get dramatically faster queries with up to 97% accuracy.

Instead of checking every single value, it uses statistical methods to estimate the count. This means we get queries that run dramatically faster while staying around about 3% of the exact count.

020

Jeff Smith @thatjeffsmith.com · 05/03/2025

Asked and answered, does our SQL Developer extension support debugging PL/SQL with booleans?

140

Jeff Smith @thatjeffsmith.com · 04/03/2025

Garmin lied to me about how ready I was for this.

010

Jeff Smith @thatjeffsmith.com · 25/02/2025

Open vs code Access marketplace Search for sqldev, right click This will work if it's not already installed. This is a known marketplace bug on msft side of house.

110

Jeff Smith @thatjeffsmith.com · 24/02/2025

Found someone to make my baby nice and shiny again.

050

Jeff Smith @thatjeffsmith.com · 23/02/2025

Less than halfway through and already thinking this needs an immediate 2nd listen. Maynard and crew put on a great show last year in Raleigh, too.

130

Jeff Smith @thatjeffsmith.com · 14/02/2025

Severe income inequality as demonstrated by @chandlerdba.bsky.social chandlerdba.com/2025/02/03/i... ♾️ in #oracle #sql

061

Jeff Smith @thatjeffsmith.com · 13/02/2025

I should go back sometime. Except this time not drink the beer at 10k+ ft elevation and almost dying trying to ski down.

110

Jeff Smith @thatjeffsmith.com · 12/02/2025

I asked the AI for a deadlift pr attempt rep scheme...what say ou?

Deadlift PR Session Outline
Objective: Successfully lift 200kg in a deadlift PR attempt.

Session Duration: 15 minutes (excluding warm-up)

Build-Up Sets & PR Attempt (15 minutes)
0-2 minutes: 120kg for 2 reps
2-4 minutes: 150kg for 1 rep
4-6 minutes: 170kg for 1 rep
6-9 minutes: 185kg for 1 rep
9-12 minutes: Rest and mentally prepare for PR attempt
12-15 minutes:
Attempt 1: 200kg for 1 rep
If successful, end session here.
If unsuccessful, use remaining time to rest (if any) and attempt:
Attempt 2: 200kg for 1 rep (if time permits)

110

Jeff Smith @thatjeffsmith.com · 10/02/2025

Starting your Oracle Database dev project has never been easier. SQL > project init -name LFG -schemas hr,sh,oe We'll extract everything from the database & create your local dev env with SRC and DIST folders, including your first installer (install.sql) Docs: docs.oracle.com/en/database/...

0110

Jeff Smith @thatjeffsmith.com · 10/02/2025

Catching up on how to read execution plans for vector searches via HNSW indexes in Oracle Database Count Stopkey | Sort Order By Stopkey | Vector Index HNSW Scan In-Filter... docs.oracle.com/en/database/...

030

Jeff Smith @thatjeffsmith.com · 08/02/2025

When throwing a bourbon party, maintaining hydration is key.

080

Jeff Smith @thatjeffsmith.com · 30/01/2025

Today is the day I realized Oracle Database 23ai ships with a ton of built-in DOMAINs You can see these via select name,data_display from all_domains where owner = 'SYS' order by name;

SQL> create table if not exists domains (
2 city city_d,
3 country country_d,
4 mobile phone_number_d
5 );

Table DOMAINS created.

SQL> ddl domains
CREATE TABLE "HR"."DOMAINS"
( "CITY" VARCHAR2(100) DOMAIN "SYS"."CITY_D",
"COUNTRY" VARCHAR2(100) DOMAIN "SYS"."COUNTRY_D",
"MOBILE" VARCHAR2(17) DOMAIN "SYS"."PHONE_NUMBER_D"
);

0145