Jeff Smith
LightNews LightNews
banner
thatjeffsmith.com
Jeff Smith
@thatjeffsmith.com
1.1K followers 580 following 7.4K posts
A product manager for Oracle Database, specializing in database developer productivity. Blogs @ https://www.thatjeffsmith.com

🌟 SQL
⭕ Oracle
📊 Databases
🏋️‍♂️ Weights, poorly
🥃 Bourbon
🕸️ REST API
🙊 Product Manager
🤘 80's hair metal fan
Posts Replies Media Videos
thatjeffsmith.com
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)
November 17, 2025 at 6:18 PM
thatjeffsmith.com
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.
November 7, 2025 at 7:55 PM
thatjeffsmith.com
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.
November 6, 2025 at 10:46 PM
thatjeffsmith.com
Birds at the beach
September 20, 2025 at 10:20 PM
thatjeffsmith.com
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'
September 19, 2025 at 12:43 PM
thatjeffsmith.com
Clicking the 'edit in settings' hyperlinked text takes me to

Settings with this filter/search applied
"sqldeveloper.connections.tnsConfiguration.path"
September 9, 2025 at 1:46 PM
thatjeffsmith.com
Gave the cousins a bath
M3 and A5
September 6, 2025 at 6:28 PM
thatjeffsmith.com
How did this only sell 6 million copies?
August 17, 2025 at 7:25 PM
thatjeffsmith.com
Official announcement/introduction to our MCP Server for Oracle Database

blogs.oracle.com/database/pos...
July 16, 2025 at 3:35 PM
thatjeffsmith.com
Now playing
Two 1980s records Europe's The Final Countdown Alice Cooper's Poison
July 12, 2025 at 8:07 PM
thatjeffsmith.com
Agent mode upgraded with an MCP Server for Oracle Database, yes please!

oracle.com/sqlcl
July 10, 2025 at 9:44 PM
thatjeffsmith.com
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...
July 10, 2025 at 9:42 PM
thatjeffsmith.com
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
July 8, 2025 at 12:52 PM
thatjeffsmith.com
we have an official MCP Server for Oracle Database as of...today
July 7, 2025 at 6:38 PM
thatjeffsmith.com
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"
June 26, 2025 at 7:39 PM
thatjeffsmith.com
Father's day sorted
June 15, 2025 at 10:42 PM
thatjeffsmith.com
Paging @datachick.bsky.social
June 5, 2025 at 9:56 PM
thatjeffsmith.com
Terminal (CLI) life can be pleasant, if not enjoyable! #Oracle gives you what you need, and then some.
June 5, 2025 at 11:19 AM
thatjeffsmith.com
Will get Search sorted, and the typo

You can share, there's an EZ Code to the right on each page
June 3, 2025 at 7:22 PM
thatjeffsmith.com
Ouch
May 17, 2025 at 3:27 PM
thatjeffsmith.com
Do you like this @vscode.dev debugger option?
May 9, 2025 at 2:08 PM
thatjeffsmith.com
Someone at my gym must be the happiest man alive
April 26, 2025 at 2:31 PM
thatjeffsmith.com
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.
April 16, 2025 at 5:55 PM
thatjeffsmith.com
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.
March 26, 2025 at 6:33 PM
thatjeffsmith.com
Happy Friday / weekend!
March 22, 2025 at 12:29 AM