-
Generate INSERTs the new 26ai way
Six years ago(!) I did an Office Hours session where I demonstrated a little routine that would let you generate more efficient INSERTs by converting a standard INSERT-VALUES into a multi-table insert (INSERT ALL) in order to reduce the number of network trips. Of course that is a moot point with 26ai because we have… Read more
-
INSERT-VALUES – Bigger is NOT always Better!
One of the super cool features in 26ai is the ability to extend the VALUES clause in your INSERT statements to allow multiple rows per execution. If you’re unfamiliar with that, here’s a quick video I did on this a while back This can be useful not just for brevity but also for performance, especially… Read more
-
SQL Macros make so many things easier
Addenda Feb 20: I had one colleague point out a mistake, then another colleague point out something else, then I thought about it a little and found other problems…sigh. So if you grabbed the original version of this function, please chuck it out and use the fresh one 🙂 The more I use SQL Macros,… Read more
-
26ai Quick Tip for Database Links
It seems an odd thing that so many facilities on the cloud environment take advantage of the concept of stored database credentials when it comes to authenticating/authorising access to those facilities, but a database link on your on-premise database typically will still require the username and password hard-coded as part of the DDL in the… Read more
-
Datatype Discipline – Even more so in 26ai
I know … I know … I probably sound like a broken record. As I scroll back through my blog archives, I see myself continuously bleating on about using data types carefully in the database. But rest assured – I ain’t done! Yes, I’m back with another warning about taking care when mixing and matching… Read more
-
The new Boolean … What about existing apps?
Yes you can throw some shade Oracle’s way for taking so long, but we now finally have a Boolean datatype arriving in the latest version of the database. SQL> create table person ( 2 pid int, 3 married boolean); Table created. SQL> insert into person values (1,true); 1 row created. SQL> insert into person values… Read more
-
What grabbed your attention in 2025
A quick summary of the things you seemed to enjoy most last year Top 3 blog posts The AI World download We’ve all been there… You head over to the Session Catalog for AI World and you want to download the files for all of the sessions you have been to, and all of the… Read more
-
Software quality – Grok and my friend’s boat
You might be wondering how a friend’s boat has any relation to the topic of software quality, but bear with me – we’ll get there in a second. But first, if you’ve got a Twitter account, you’ve probably had the unfortunate experience over the past few days of people using Grok to turn people’s pictures… Read more
-
2025 … wrapped
Just a brief selection of memories from conferences and events throughout 2025. It’s been wonderfully rewarding to share my knowledge on the Oracle database to so many people this year. 2026 will bring new things with Oracle Database, which will continue to amaze! Read more
-
Transaction Priorities in 26ai – open season on locking
One of the cool features in Oracle AI Database 26ai is the ability for sessions to have different levels of priority for their transaction locks. I’ve covered how the feature works in the video below In a nutshell, a session can nominate whether their locking priority is LOW, MEDIUM or HIGH. When a session tries… Read more
-
An AI generated SQL for Christmas
A couple of years back I posted a simple SQL to draw a Christmas tree, complete with colours and randomly placed lights using the Windows terminal colour codes to. My SQL ended up like this: with codes as (select ‘[1;’ s1, ‘[0m’ e1 , rpad(‘X’,40,’X’) s, rpad(‘T’,40,’T’) t from dual) select replace( replace( replace(r,’X’,chr(27)||'[42m’||chr(27)||s1||to_char(32)||’m’||’X’||chr(27)||e1), ‘T’,chr(27)||'[43m’||chr(27)||s1||to_char(33)||’m’||’T’||chr(27)||e1),… Read more
-
The Christmas database
With Oracle AI Database 26ai finally ready for on-prem release, it means we can all celebrate a little something at Christmas time 🙂 On the first day of Christmas, my DB gave to me… A VECTOR for similarity. On the second day of Christmas, my DB gave to me… Two duality views, And a… Read more