Learning #SQL for your 2026 New Year's Resolution?
Head to Oracle Dev Gym
This has FREE classes to take you from
Your first SELECT & CREATE TABLE statements
On to recursive WITH and window function queries
And learning how to make these fast
Join at devgym.oracle.com/pls/apex/d…
Oracle Spatial Studio enables you to visualize data on a map
This enables you to see how stats vary by region
@OyvindIsene uses this to visualize Norwegian kindergarten stats by area
enesi.no/2026/10/oracle-spat…
Want to clone a schema within Oracle AI Database?
@kibeha shows how you can use
The database's global name as a loopback DB link
The link to import a schema to another within the DB
impdp system@... network_link=GLOBAL_NAME schemas=... remap_schema=...
kibeha.dk/2026/10/datapump-o…
The QUALIFY clause, added to Oracle #SQL in 23.26.0, enables you to filter window functions:
QUALIFY RANK () OVER ( ... )
@Andrej_SQL looks under the covers:
It wraps the function in a Boolean expression
But the optimizer can still push predicates
blog.sqlora.com/en/oracle-26…
Generate v5 and v7 UUIDs in Oracle AI Database from release 23.26.4
SELECT UUID ( 7 ), UUID ( 5, 'namespace', 'name' )
The IS_UUID function validates values are v4, v5 or v7 UUIDs with optional version verification
Proxy users in Oracle AI Database can connect as another user
CREATE USER usr NO AUTHENTICATION
CREATE USER proxy IDENTIFIED BY ...
ALTER USER usr GRANT CONNECT THROUGH proxy
But how do auditing and password changes work for these?
@sdstuber inspects seanstuber.com/2026/10/14/lo…
Ever had your PL/SQL changes overwritten by someone else?
*%&! annoying, isn't it?
To stop this @r_grzegorczyk has picked up support of Loki
A tool that enables you to lock database objects
What features would you like to see from this?
rafal.hashnode.dev/who-chang…
Want many AI agents to develop in parallel against Oracle AI Database?
Using one schema they'll get in each other's way
@dgielis shows how you can give each their own sandbox with PDB clones
CREATE PLUGGABLE DATABASE ...
FROM ... SNAPSHOT COPY
dgielis.com/every-agent-gets…
Run top-N queries with FOR UPDATE in Oracle #SQL from 23.26.4:
SELECT ...
FETCH FIRST n ROWS ONLY
FOR UPDATE
Add SKIP LOCKED to enable many batch processes get and lock the next N rows in parallel
There are many data modeling methods
Joe Reis identifies five and covers their pros and cons:
Relational - normal forms
Analytics - Inmon/Kimball
Application - JSON
ML/AI - vector
Knowledge - ontologies & taxonomies
Which camp are you in?
practicaldatamodeling.substa…
Got a string of numbers, say "1,4,5,3,2,6", you'd like to sort with Oracle #SQL?
Phil Grinham shows how you can by:
Splitting the string into rows
Using LISTAGG to recombine them in order
Turn this into a macro to so you can reuse the logic
philgrinham.hashnode.dev/bub…
Define row and column level security with #SQL using Oracle's Deep Data Security in 23.26.2
Use this to define
END USERs with
DATA ROLEs which have
DATA GRANTs which are SQL expressions defining the access
Jim Czuprynski shows you how to use it red-gate.com/simple-talk/dat…
Like wordsearches? Like #SQL?
Meet #SeeQLer
A daily SQL keyword search
Find the keywords in the grid that replace ???? in the statement:
???? work_shifts ???? leave_office_ts = leave_office_ts - ???? '1' ????
???? shift_date = ???? ( ???? )
Play at devgym.oracle.com/pls/apex/f…
A foreign key can only point to one table.
Which is a problem if a column can reference exactly one of two parent tables
No data integrity constraints!
@plamen_9 shows how you can use assertions in Oracle AI Database to fill this gap
blog.apexapplab.dev/oracle-2…
Is fighting with duplicate rows in #SQL a common challenge for you?
Dani Schnider shows options you can use to detect and remove them
DISTINCT
GROUP BY HAVING COUNT (*) > 1
QUALIFY RANK () OVER ( ... ) = 1
And covers their pros & cons danischnider.wordpress.com/2…
Trying to explain database concepts? Or demonstrate an error?
Create a demo!
This makes it easy for others to verify what you're claiming
@pdevisse advises
Keep It Simple.
Runnable from any prompt
Minimal setup
Easily re-runnable
Have its own cleanup
simpleoracledba.blogspot.com…
Oracle AI Database 23.26.4 is here!
With it comes a host of new #SQL features, big and small
SELECT *, <expr>
You can now combine SELECT * with other expressions, e.g.
SELECT SYSDATE, ROWID, * FROM ...
BAR_CHART
A function to make simple ASCII bar charts
Simplified Macros
A new CREATE MACRO statement that accepts static SQL scalar or table expressions
CREATE MACRO scalar_m IS <expr>
CREATE MACRO table_m IS SELECT ...
Window table value functions
Group rows into windows
TUMBLE - consecutive, fixed-size windows
HOP - sliding, fixed-size windows
CUMULATE - cumulative results; total daily sales by hour
SESSIONS - combine rows within N of the previous into one group
From 23.26.2 you can nest WITH clauses in Oracle #SQL
@vahidusefzadeh walks through rewriting a plain SELECT to find total complete orders into nested WITH
WITH totals AS ( WITH completed AS ( ... ) SELECT completed ... )
SELECT totals ...
dev.to/vahidusefzadeh/nested…



![SELECT FOR UPDATE FETCH FIRST [ SKIP LOCKED ] (23.26.4) Combine top-N queries with FOR UPDATE Session 1 locks employee 100; Session 2 gets and locks the first 3 unlocked employee ID, skipping emp 100](https://pbs.twimg.com/media/HWrpBJMWYAEr8_q.jpg?name=small&format=webp)







