Learning is not a spectator sport

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

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:

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 repo here and if you have any experience with the Oracle database, I encourage you to examine the details and offer any feedback so...

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 SQL from plain English, it seems “obvious” that we have abstracted away the need to understand the language itself.

My thoughts are that the exact opposite is true: Learning SQL is more important than ever.

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 a blog, here’s the TL;DR – You can use the column alias in your GROUP BY, to avoid the annoying duplication of code

Old-school way