Oh dang, now I can't break the DevGym data anymore 😇
With assertions in 23.26.1 you can define cross-table constraints
Answers can only be submitted while a question is live
Every question must have at least one choice
Only one choice can be true for single-choice questions
Find out how in my latest post blogs.oracle.com/sql/how-to-d...
Answers can only be submitted while a question is live
Every question must have at least one choice
Only one choice can be true for single-choice questions
Find out how in my latest post blogs.oracle.com/sql/how-to-d...
January 28, 2026 at 2:54 PM
Oh dang, now I can't break the DevGym data anymore 😇
I learned that by now there's been over three hundred thousand answers to Oracle DevGym quizzes authored by me... That's a 3 followed by 5 zeroes 😁.
Whaddya mean you haven't heard of the DevGym? Then you should immediately go to devgym.oracle.com and try out your skills in SQL, PL/SQL and more.
Whaddya mean you haven't heard of the DevGym? Then you should immediately go to devgym.oracle.com and try out your skills in SQL, PL/SQL and more.
a man in a suit and tie says " we 'll have a little bit of a quiz " in front of a white board
ALT: a man in a suit and tie says " we 'll have a little bit of a quiz " in front of a white board
media.tenor.com
December 19, 2024 at 2:24 PM
I learned that by now there's been over three hundred thousand answers to Oracle DevGym quizzes authored by me... That's a 3 followed by 5 zeroes 😁.
Whaddya mean you haven't heard of the DevGym? Then you should immediately go to devgym.oracle.com and try out your skills in SQL, PL/SQL and more.
Whaddya mean you haven't heard of the DevGym? Then you should immediately go to devgym.oracle.com and try out your skills in SQL, PL/SQL and more.
Quizzes on Oracle DevGym is fun.
And it just got easier to get started 🤩
And it just got easier to get started 🤩
July 1, 2026 at 10:09 AM
Quizzes on Oracle DevGym is fun.
And it just got easier to get started 🤩
And it just got easier to get started 🤩
Fresh Blog Note: quanwenzhao.wordpress.com/2025/10/19/q...
@oracledatabase.bsky.social @oracleasktom.bsky.social #LiveSQL #DevGym @oraclecloud.bsky.social #23ai #26ai #SQL #NewFeatures #OCI #Qualifyclause #AutonomousAIDatabase
@oracledatabase.bsky.social @oracleasktom.bsky.social #LiveSQL #DevGym @oraclecloud.bsky.social #23ai #26ai #SQL #NewFeatures #OCI #Qualifyclause #AutonomousAIDatabase
Qualify clause
On Oracle AI World 2025 (Oct 15th, 2025) oracle replaced 23ai (23.9) to 26ai (23.26 market version, aka 23.10 technology version). Namely the latest oracle version is Oracle AI Database 26ai. Meanw…
quanwenzhao.wordpress.com
October 19, 2025 at 10:40 PM
SQL 1992 - where (col1, col2) is not null - simplify SQL and easy more to read - forums.oracle.com/ords/apexds/... @oracledatabase.bsky.social @oracleasktom.bsky.social @oracledev.bsky.social #DevGym #database #sql #oracle
forums.oracle.com
October 29, 2025 at 9:52 AM
SQL 1992 - where (col1, col2) is not null - simplify SQL and easy more to read - forums.oracle.com/ords/apexds/... @oracledatabase.bsky.social @oracleasktom.bsky.social @oracledev.bsky.social #DevGym #database #sql #oracle
Thanks @chrisrsaxon.bsky.social for putting #SpeedSQL on the homepage of #DevGym of @oracledatabase.bsky.social to make it possible …
Speed SQL results for quiz on 20-AUG-2025
Attempt #1: 10 correct in 56 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 20-AUG-2025
Attempt #1: 10 correct in 56 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
August 20, 2025 at 4:55 AM
Thanks @chrisrsaxon.bsky.social for putting #SpeedSQL on the homepage of #DevGym of @oracledatabase.bsky.social to make it possible …
Speed SQL results for quiz on 20-AUG-2025
Attempt #1: 10 correct in 56 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 20-AUG-2025
Attempt #1: 10 correct in 56 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Calculating a running total and moving average with the same window in #SQL?
The naive way duplicates the PARTITION BY and ORDER BY clauses
Better: define them once in the WINDOW
SELECT SUM OVER w, AVG OVER w
...
WINDOW w AS ( ... )
Harris Fungwi buff.ly/JfCQ5VE
The naive way duplicates the PARTITION BY and ORDER BY clauses
Better: define them once in the WINDOW
SELECT SUM OVER w, AVG OVER w
...
WINDOW w AS ( ... )
Harris Fungwi buff.ly/JfCQ5VE
The WINDOW Clause in Oracle SQL -
Background One of the best resources for anyone who’s into oracle tech is this site called the devgym. It contains games, quizzes, classes and workouts all designed to help build developers’ Oracle…
buff.ly
September 2, 2026 at 11:01 AM
Calculating a running total and moving average with the same window in #SQL?
The naive way duplicates the PARTITION BY and ORDER BY clauses
Better: define them once in the WINDOW
SELECT SUM OVER w, AVG OVER w
...
WINDOW w AS ( ... )
Harris Fungwi buff.ly/JfCQ5VE
The naive way duplicates the PARTITION BY and ORDER BY clauses
Better: define them once in the WINDOW
SELECT SUM OVER w, AVG OVER w
...
WINDOW w AS ( ... )
Harris Fungwi buff.ly/JfCQ5VE
I only spotted it because I had recently written a DevGym quiz about the compiler never checking what label name you use in END LOOP...
August 11, 2026 at 1:38 PM
I only spotted it because I had recently written a DevGym quiz about the compiler never checking what label name you use in END LOOP...
New Blog Post: Playing with (Simulating ORA-30926 on 19c vs 23ai) on Live SQL - quanwenzhao.wordpress.com/2025/05/31/p...
@oracledatabase.bsky.social #OracleDevs #OracleUniversity #OracleUserGroups #OracleLiveSQL @oracleasktom.bsky.social #DevGym #19c #23ai #merge #SQL #PLSQL #ORA30926 #demo
@oracledatabase.bsky.social #OracleDevs #OracleUniversity #OracleUserGroups #OracleLiveSQL @oracleasktom.bsky.social #DevGym #19c #23ai #merge #SQL #PLSQL #ORA30926 #demo
Playing with (Simulating ORA-30926 on 19c vs 23ai) on Live SQL
Based on the previous note I’ve continued to explore it. As well known as I used the 3 number of rewriting methods ( to correct the original merge sql statement. Chris Saxon shared “2 W…
quanwenzhao.wordpress.com
May 31, 2025 at 12:27 PM
New Blog Post: Playing with (Simulating ORA-30926 on 19c vs 23ai) on Live SQL - quanwenzhao.wordpress.com/2025/05/31/p...
@oracledatabase.bsky.social #OracleDevs #OracleUniversity #OracleUserGroups #OracleLiveSQL @oracleasktom.bsky.social #DevGym #19c #23ai #merge #SQL #PLSQL #ORA30926 #demo
@oracledatabase.bsky.social #OracleDevs #OracleUniversity #OracleUserGroups #OracleLiveSQL @oracleasktom.bsky.social #DevGym #19c #23ai #merge #SQL #PLSQL #ORA30926 #demo
New Blog Post: do not panic for “ORA-01403: no data found” - quanwenzhao.wordpress.com/2025/04/25/d...
@oracleasktom.bsky.social @oracledatabase.bsky.social #LiveSQLv2 #23ai #SQL #PLSQL #DevGym #OracleUserGroups
@oracleasktom.bsky.social @oracledatabase.bsky.social #LiveSQLv2 #23ai #SQL #PLSQL #DevGym #OracleUserGroups
do not panic for “ORA-01403: no data found”
Yesterday my middleware colleague asked me an interesting question he encounted the error about “ORA-01403: no data found” in his test program code. I told him do not panic for this err…
quanwenzhao.wordpress.com
April 25, 2025 at 12:43 PM
New Blog Post: do not panic for “ORA-01403: no data found” - quanwenzhao.wordpress.com/2025/04/25/d...
@oracleasktom.bsky.social @oracledatabase.bsky.social #LiveSQLv2 #23ai #SQL #PLSQL #DevGym #OracleUserGroups
@oracleasktom.bsky.social @oracledatabase.bsky.social #LiveSQLv2 #23ai #SQL #PLSQL #DevGym #OracleUserGroups
#OrclDB #DevGym Learn SQL in this FREE 12-part boot camp. It will help you get started with Oracle Database and SQL. The course is a series of videos to teach you database concepts, interactive SQL tutorials, and quizzes to reinforce the ideas.
https://buff.ly/2Od3spl
https://buff.ly/2Od3spl
Learn SQL with this FREE Online Course - Oracle Dev Gym
Learn SQL in this FREE, online, 12-part tutorial with a c...
buff.ly
November 25, 2024 at 1:30 PM
#OrclDB #DevGym Learn SQL in this FREE 12-part boot camp. It will help you get started with Oracle Database and SQL. The course is a series of videos to teach you database concepts, interactive SQL tutorials, and quizzes to reinforce the ideas.
https://buff.ly/2Od3spl
https://buff.ly/2Od3spl