Jeff Smith
@thatjeffsmith.com
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
π SQL
β Oracle
π Databases
ποΈββοΈ Weights, poorly
π₯ Bourbon
πΈοΈ REST API
π Product Manager
π€ 80's hair metal fan
Pinned
Jeff Smith
@thatjeffsmith.com
Β· Nov 15
π‘ Tip: Working with lots of different databases and don't want to accidentally drop a table in your PROD Oracle system?
PS if you've never done this, you've probably not been in IT for very long #riteOfpassage
Use emojis in your connection names π΄ π‘ π’
Tip 2: STAY OUT OF PRODUCTION :)
PS if you've never done this, you've probably not been in IT for very long #riteOfpassage
Use emojis in your connection names π΄ π‘ π’
Tip 2: STAY OUT OF PRODUCTION :)
Previously on @thatjeffsmith... A quick note on Creating PDBs using REST APIs with ORDS
A quick note on Creating PDBs using REST APIs with ORDS
Previously on @thatjeffsmith... A quick note on Creating PDBs using REST APIs with ORDS
www.thatjeffsmith.com
February 13, 2026 at 1:40 PM
Previously on @thatjeffsmith... A quick note on Creating PDBs using REST APIs with ORDS
Previously on @thatjeffsmith... QUICKLY access database object metadata via DBMS_DEVELOPER
QUICKLY access database object metadata via DBMS_DEVELOPER
Previously on @thatjeffsmith... QUICKLY access database object metadata via DBMS_DEVELOPER
www.thatjeffsmith.com
February 13, 2026 at 5:38 AM
Previously on @thatjeffsmith... QUICKLY access database object metadata via DBMS_DEVELOPER
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
Example: Loading Chicago Crime Data (CSV) with SQLcl
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
www.thatjeffsmith.com
February 12, 2026 at 9:39 PM
Previously on @thatjeffsmith... Example: Loading Chicago Crime Data (CSV) with SQLcl
Previously on @thatjeffsmith... Go to Declaration vs Peek in SQLDev for VS Code
Go to Declaration vs Peek in SQLDev for VS Code
Previously on @thatjeffsmith... Go to Declaration vs Peek in SQLDev for VS Code
www.thatjeffsmith.com
February 12, 2026 at 1:39 PM
Previously on @thatjeffsmith... Go to Declaration vs Peek in SQLDev for VS Code
Previously on @thatjeffsmith... Retrieve DISTINCT list of values from JSON arrays via SQL
Retrieve DISTINCT list of values from JSON arrays via SQL
Previously on @thatjeffsmith... Retrieve DISTINCT list of values from JSON arrays via SQL
www.thatjeffsmith.com
February 12, 2026 at 5:36 AM
Previously on @thatjeffsmith... Retrieve DISTINCT list of values from JSON arrays via SQL
Previously on @thatjeffsmith... SQL Developer for VS Code 25.1: Connection Folders are here!
SQL Developer for VS Code 25.1: Connection Folders are here!
Previously on @thatjeffsmith... SQL Developer for VS Code 25.1: Connection Folders are here!
www.thatjeffsmith.com
February 11, 2026 at 9:38 PM
Previously on @thatjeffsmith... SQL Developer for VS Code 25.1: Connection Folders are here!
Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types
On REST APIs and Oracle Database 23ai JSON native types
Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types
www.thatjeffsmith.com
February 11, 2026 at 1:37 PM
Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types
Previously on @thatjeffsmith... Having fun with SQLDev connection names π¨π°π€οΈ
Having fun with SQLDev connection names π¨π°π€οΈ
Previously on @thatjeffsmith... Having fun with SQLDev connection names π¨π°π€οΈ
www.thatjeffsmith.com
February 11, 2026 at 5:38 AM
Previously on @thatjeffsmith... Having fun with SQLDev connection names π¨π°π€οΈ
Previously on @thatjeffsmith... Using Claude to βfixβ my table comments via our MCP Server
Using Claude to βfixβ my table comments via our MCP Server
Previously on @thatjeffsmith... Using Claude to βfixβ my table comments via our MCP Server
www.thatjeffsmith.com
February 10, 2026 at 9:39 PM
Previously on @thatjeffsmith... Using Claude to βfixβ my table comments via our MCP Server
Previously on @thatjeffsmith... Oracle SQL Developer 23.1.1 is now available
Oracle SQL Developer 23.1.1 is now available
Previously on @thatjeffsmith... Oracle SQL Developer 23.1.1 is now available
www.thatjeffsmith.com
February 10, 2026 at 1:38 PM
Previously on @thatjeffsmith... Oracle SQL Developer 23.1.1 is now available
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
SQL Developer extension for VS Code 25.3: Charts & Diagrams
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
www.thatjeffsmith.com
February 10, 2026 at 5:39 AM
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
Previously on @thatjeffsmith... Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6
Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6
Previously on @thatjeffsmith... Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6
www.thatjeffsmith.com
February 9, 2026 at 9:37 PM
Previously on @thatjeffsmith... Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6
Previously on @thatjeffsmith... SQL Developer Extension for VS Code 24.2 is now available
SQL Developer Extension for VS Code 24.2 is now available
Previously on @thatjeffsmith... SQL Developer Extension for VS Code 24.2 is now available
www.thatjeffsmith.com
February 9, 2026 at 1:40 PM
Previously on @thatjeffsmith... SQL Developer Extension for VS Code 24.2 is now available
Previously on @thatjeffsmith... Building a new app schema database using Windsurf and GPT-5
Building a new app schema database using Windsurf and GPT-5
Previously on @thatjeffsmith... Building a new app schema database using Windsurf and GPT-5
www.thatjeffsmith.com
February 9, 2026 at 5:37 AM
Previously on @thatjeffsmith... Building a new app schema database using Windsurf and GPT-5
Previously on @thatjeffsmith... Using SQL Developer for VS Code to build Duality Views
Using SQL Developer for VS Code to build Duality Views
Previously on @thatjeffsmith... Using SQL Developer for VS Code to build Duality Views
www.thatjeffsmith.com
February 8, 2026 at 9:38 PM
Previously on @thatjeffsmith... Using SQL Developer for VS Code to build Duality Views
Previously on @thatjeffsmith... ORA-00918: column ambiguously specified, but what column?
ORA-00918: column ambiguously specified, but what column?
Previously on @thatjeffsmith... ORA-00918: column ambiguously specified, but what column?
www.thatjeffsmith.com
February 8, 2026 at 1:38 PM
Previously on @thatjeffsmith... ORA-00918: column ambiguously specified, but what column?
Previously on @thatjeffsmith... Insights & FAQS from speaking to folks re: our MCP Server
Insights & FAQS from speaking to folks re: our MCP Server
Previously on @thatjeffsmith... Insights & FAQS from speaking to folks re: our MCP Server
www.thatjeffsmith.com
February 8, 2026 at 5:41 AM
Previously on @thatjeffsmith... Insights & FAQS from speaking to folks re: our MCP Server
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
February 7, 2026 at 9:36 PM
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Definitive guide to moving from SQL Developer to VS Code
Definitive guide to moving from SQL Developer to VS Code
Previously on @thatjeffsmith... Definitive guide to moving from SQL Developer to VS Code
www.thatjeffsmith.com
February 7, 2026 at 1:36 PM
Previously on @thatjeffsmith... Definitive guide to moving from SQL Developer to VS Code
Previously on @thatjeffsmith... Another update for our SQL Developer Extension for VS Code
Another update for our SQL Developer Extension for VS Code
Previously on @thatjeffsmith... Another update for our SQL Developer Extension for VS Code
www.thatjeffsmith.com
February 7, 2026 at 5:41 AM
Previously on @thatjeffsmith... Another update for our SQL Developer Extension for VS Code
Previously on @thatjeffsmith... Working with objects in your Oracle Database with VS Code
Working with objects in your Oracle Database with VS Code
Previously on @thatjeffsmith... Working with objects in your Oracle Database with VS Code
www.thatjeffsmith.com
February 6, 2026 at 9:38 PM
Previously on @thatjeffsmith... Working with objects in your Oracle Database with VS Code
Previously on @thatjeffsmith... Oracle Database 23ai News & an Updated VirtualBox appliance
Oracle Database 23ai News & an Updated VirtualBox appliance
Previously on @thatjeffsmith... Oracle Database 23ai News & an Updated VirtualBox appliance
www.thatjeffsmith.com
February 6, 2026 at 1:37 PM
Previously on @thatjeffsmith... Oracle Database 23ai News & an Updated VirtualBox appliance
Previously on @thatjeffsmith... SQLcl 24.2 Quick Hit: Generating AWR Reports
SQLcl 24.2 Quick Hit: Generating AWR Reports
Previously on @thatjeffsmith... SQLcl 24.2 Quick Hit: Generating AWR Reports
www.thatjeffsmith.com
February 6, 2026 at 5:36 AM
Previously on @thatjeffsmith... SQLcl 24.2 Quick Hit: Generating AWR Reports
Previously on @thatjeffsmith... AI Schema Enrichment + a new MCP Tool = Simpler Prompts
AI Schema Enrichment + a new MCP Tool = Simpler Prompts
Previously on @thatjeffsmith... AI Schema Enrichment + a new MCP Tool = Simpler Prompts
www.thatjeffsmith.com
February 5, 2026 at 9:40 PM
Previously on @thatjeffsmith... AI Schema Enrichment + a new MCP Tool = Simpler Prompts
Previously on @thatjeffsmith... Asking AI to generate test data, more is better
Asking AI to generate test data, more is better
Previously on @thatjeffsmith... Asking AI to generate test data, more is better
www.thatjeffsmith.com
February 5, 2026 at 1:38 PM
Previously on @thatjeffsmith... Asking AI to generate test data, more is better