@quanwenzhao.bsky.social
Being fond of communicating Oracle Tech with some domestic and overseas guys, is @oracleace.bsky.social alumni and any opinions are my own. You can contact me by https://linktr.ee/quanwenzhao.
Pinned
Welcome to fork and reship my latest GitHub repository about Oracle 23ai New Features Demos on 2025 to your @bsky.app social media to let more @oracledatabase.bsky.social friends know, thank you so much! github.com/guestart/Ora...
Speed SQL results for quiz on 13-NOV-2025
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 13, 2025 at 4:47 AM
Speed SQL results for quiz on 13-NOV-2025
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 12-NOV-2025
Attempt #1: 10 correct in 53 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 53 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 12, 2025 at 4:24 AM
Speed SQL results for quiz on 12-NOV-2025
Attempt #1: 10 correct in 53 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 53 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 11-NOV-2025
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 11, 2025 at 4:53 AM
Speed SQL results for quiz on 11-NOV-2025
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 10-NOV-2025
Attempt #1: 10 correct in 54 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 54 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 10, 2025 at 4:24 AM
Speed SQL results for quiz on 10-NOV-2025
Attempt #1: 10 correct in 54 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 54 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 09-NOV-2025
Attempt #1: 10 correct in 49 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 49 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 9, 2025 at 1:57 AM
Speed SQL results for quiz on 09-NOV-2025
Attempt #1: 10 correct in 49 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 49 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
SQuizL 09-NOV-25
5/6 guesses
402 seconds
⬜⬜⬜⬜⬜🟦⬜
🟩🟩⬜🟩🟩🟦⬜
🟩🟩⬜🟩🟩🟦🟩
🟩🟩⬜🟩🟩🟦🟩
🟩🟩🟩🟩🟩🟦🟩
bit.ly/SQuizL-game
#SQuizL #SQL
5/6 guesses
402 seconds
⬜⬜⬜⬜⬜🟦⬜
🟩🟩⬜🟩🟩🟦⬜
🟩🟩⬜🟩🟩🟦🟩
🟩🟩⬜🟩🟩🟦🟩
🟩🟩🟩🟩🟩🟦🟩
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
November 9, 2025 at 1:56 AM
SQuizL 09-NOV-25
5/6 guesses
402 seconds
⬜⬜⬜⬜⬜🟦⬜
🟩🟩⬜🟩🟩🟦⬜
🟩🟩⬜🟩🟩🟦🟩
🟩🟩⬜🟩🟩🟦🟩
🟩🟩🟩🟩🟩🟦🟩
bit.ly/SQuizL-game
#SQuizL #SQL
5/6 guesses
402 seconds
⬜⬜⬜⬜⬜🟦⬜
🟩🟩⬜🟩🟩🟦⬜
🟩🟩⬜🟩🟩🟦🟩
🟩🟩⬜🟩🟩🟦🟩
🟩🟩🟩🟩🟩🟦🟩
bit.ly/SQuizL-game
#SQuizL #SQL
Speed SQL results for quiz on 08-NOV-2025
Attempt #1: 9 correct in 59 seconds
✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 59 seconds
✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 8, 2025 at 1:54 AM
Speed SQL results for quiz on 08-NOV-2025
Attempt #1: 9 correct in 59 seconds
✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 59 seconds
✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
SQuizL 08-NOV-25
6/6 guesses
631 seconds
⬜🟨⬜⬜🟦⬜⬜
⬜🟨🟨🟨🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
6/6 guesses
631 seconds
⬜🟨⬜⬜🟦⬜⬜
⬜🟨🟨🟨🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
bit.ly
November 8, 2025 at 1:54 AM
SQuizL 08-NOV-25
6/6 guesses
631 seconds
⬜🟨⬜⬜🟦⬜⬜
⬜🟨🟨🟨🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
6/6 guesses
631 seconds
⬜🟨⬜⬜🟦⬜⬜
⬜🟨🟨🟨🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩⬜
🟩🟩🟩🟩🟦🟩🟩
bit.ly/SQuizL-game
#SQuizL #SQL
Reposted
Click, click and voila! You're connecting from your own machine!
November 7, 2025 at 3:12 PM
Click, click and voila! You're connecting from your own machine!
Reposted
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
FreeSQL.com
November 6, 2025 at 10:42 PM
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
Reposted
That's means its approximately 10x easier/faster today than it was yesterday to get started using/learning Oracle, databases, sql, and in general, data management.
November 6, 2025 at 10:46 PM
That's means its approximately 10x easier/faster today than it was yesterday to get started using/learning Oracle, databases, sql, and in general, data management.
Speed SQL results for quiz on 07-NOV-2025
Attempt #1: 9 correct in 60 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 60 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 7, 2025 at 5:07 AM
Speed SQL results for quiz on 07-NOV-2025
Attempt #1: 9 correct in 60 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 60 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
This is the content more than my other blog notes, you probably need reading it more than 15 minutes, if taking a practice you’ll spend extra a few time … thanks @sqldaily.bsky.social and @chrisrsaxon.bsky.social for reposting it to let more friends know and learn …
The KEEP clause - aka FIRST/LAST functions - in Oracle #SQL enables you to get the min/max row for one column sorted by another
MIN ( salary ) KEEP ( DENSE_RANK FIRST ORDER BY hire )
=> Get the lowest salary for the first hire
@quanwenzhao.bsky.social explores it & alternatives
MIN ( salary ) KEEP ( DENSE_RANK FIRST ORDER BY hire )
=> Get the lowest salary for the first hire
@quanwenzhao.bsky.social explores it & alternatives
Oracle FIRST/LAST functions with KEEP clause #JoelKallmanDay
A few days ago I’ve noticed that Tim Hall have announced the fabulous Oracle community activity about writing the several blog notes on the same day that is Oct 15th this year (on the 2nd or …
buff.ly
November 7, 2025 at 4:20 AM
This is the content more than my other blog notes, you probably need reading it more than 15 minutes, if taking a practice you’ll spend extra a few time … thanks @sqldaily.bsky.social and @chrisrsaxon.bsky.social for reposting it to let more friends know and learn …
Speed SQL results for quiz on 06-NOV-2025
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 6, 2025 at 4:35 AM
Speed SQL results for quiz on 06-NOV-2025
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 51 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 05-NOV-2025
Attempt #1: 9 correct in 55 seconds
✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 55 seconds
✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 5, 2025 at 1:32 AM
Speed SQL results for quiz on 05-NOV-2025
Attempt #1: 9 correct in 55 seconds
✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 9 correct in 55 seconds
✔ ✔ ✔ ✖ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 04-NOV-2025
Attempt #1: 8 correct in 55 seconds
✔ ✔ ✔ ✔ ✖ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 8 correct in 55 seconds
✔ ✔ ✔ ✔ ✖ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 4, 2025 at 4:31 AM
Speed SQL results for quiz on 04-NOV-2025
Attempt #1: 8 correct in 55 seconds
✔ ✔ ✔ ✔ ✖ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 8 correct in 55 seconds
✔ ✔ ✔ ✔ ✖ ✔ ✔ ✖ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Speed SQL results for quiz on 03-NOV-2025
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
devgym.oracle.com
November 3, 2025 at 4:51 AM
Speed SQL results for quiz on 03-NOV-2025
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...
Attempt #1: 10 correct in 47 seconds
✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔
#SpeedSQL devgym.oracle.com/pls/apex/f?p...