Jeff Smith

@thatjeffsmith.com

1137 Followers 588 Following

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

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.
VS Code preferences, keyboard shortcuts, assigning a keyboard sequence to activate 'Go to Declaration'
M3 and A5
Two 1980s records Europe's The Final Countdown Alice Cooper's Poison
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
blue t-shirt with "I'll just have the chicken tenders"
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.
Oracle Cloud Infrastructure (OCI) Console page showing the Database Tools (Developer Services) interface for searching the contents of your Oracle Database.
Oracle Database 23ai and building a Relational Duality View with domains and annotations.
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.
Slack profile status: Stop Tagging me in posts, I read them all.
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)
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" );
My doggy
Screenshot of HackerNoon story, 15 Databases, 15 Use Cases—Stop Using the Wrong Database for the Right Problem
The Cure's Songs of a Lost World record (lp)