Signal to noise ratio – the AWR trap
Its never been easier to analyze an AWR report. With our new oracle skills repository, your favourite agent can do a respectable job giving some insights into the AWR...
2026-05-06
143 reads
Connor McDonald
The new release update experience
For about the last … hmmm…maybe decade or more, when you downloaded a release update from MOS for your database, the patch would consist of a single folder which...
2026-05-04
78 reads
My APEX installer / patcher
Hopefully you have just seen that APEX patchset bundle 16 has just been released for 24.2. Of particular note is that a well-publicised Chrome change to deprecate the unload...
2026-05-01
88 reads
The unhealthy obsession with ROLLBACK
So I jumped onto an LLM and asked it to give me some PL/SQL to handle a 3-step series of DML statements and out popped the following code: That...
2026-04-30
45 reads
Unleashing Skills onto my database
You may have already seen that thanks to Kris Rice, we now have a baseline set of Oracle skills available for your favourite AI tools. Check out the skills...
2026-04-28
58 reads
SQL skills just got MORE important
There seems to be a school of thought in the tech community that a robust knowledge SQL is now optional. After all, with modern AI tools able to generate...
2026-04-22
45 reads
GROUP BY ALL – Is it ALL you ever need?
You have probably seen a couple of cool GROUP BY features that came with Oracle Database 26ai. You can check out the short video below but since you’re on...
2026-04-17
88 reads
Voxxed Days Zurich
That was my first experience at a Voxxed Days event. Obviously I like Oracle-focussed events, but that can give you a blinkered view of the world. There’s a lot...
2026-04-07
44 reads
Thank you after 21 years
Throughout my long history of working with the Oracle Database, there are some things that often just take for granted, on the assumption that they have always been present....
2026-03-12
56 reads
Bind Variables – Worse than you were told
Many of you probably know Martin Bach. He’s a colleague here at Oracle although we’ve both been good mates in the Oracle community long before either of us joined...
2026-03-09
63 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers