SQL Daily (@sqldaily) profile picture

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

Joined January 2015
Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)Photo by SQL Daily (@sqldaily)
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…
6
22
4,103
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…
3
12
858
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…
4
12
801
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
5
12
1,047
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…
2
11
826
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…
1
5
16
1,108
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…
1
3
15
1,024
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
7
18
1,216
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…
4
12
951
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…
1
3
9
809
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…
4
9
917
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…
5
13
1,022
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…
1
5
1
13
1,214
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…
1
8
12
1,000
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…
3
4
934
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 ...
2
8
17
1,589
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 ...
1
1
2
322
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
1
1
209
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…
1
9
19
1,339