#DevGym

@quanwenzhao.bsky.social

4 months ago

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

@quanwenzhao.bsky.social

4 months ago

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…

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

@quanwenzhao.bsky.social

6 months ago

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...

@quanwenzhao.bsky.social

9 months ago

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…

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

@quanwenzhao.bsky.social

10 months ago

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…

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

Biju Thomas

@bijoos.bsky.social

6 years ago

#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