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
#orcldb Execution plans on LiveSQL @oraclelivesql https://buff.ly/2FGYAnC
Execution plans on LiveSQL
To protect the integrity of people’s data, and isolate se...
buff.ly
November 28, 2024 at 7:18 PM
#orcldb Execution plans on LiveSQL @oraclelivesql https://buff.ly/2FGYAnC
Made my first contribution to @oraclelivesql community code - converted the blog post about the split function https://livesql.oracle.com/apex/f?p=590:41:111682234136401:::41:P41_ID:45299483592361385654175017993937507480
November 23, 2024 at 1:10 AM
Made my first contribution to @oraclelivesql community code - converted the blog post about the split function https://livesql.oracle.com/apex/f?p=590:41:111682234136401:::41:P41_ID:45299483592361385654175017993937507480
I'm very impressed!
Not only that this issue with @OracleLiveSQL was fixed shortly after I had reported about it. I also got mails from the developer when she started working on it, finished, and applied the fix in production.
Well done 👍
Thank you 🙂
/cc @mikehichwa1 @oracleace
Not only that this issue with @OracleLiveSQL was fixed shortly after I had reported about it. I also got mails from the developer when she started working on it, finished, and applied the fix in production.
Well done 👍
Thank you 🙂
/cc @mikehichwa1 @oracleace
Just sent a feedback to @OracleLiveSQL:
The "Download CSV" option doesn't do any escaping, so if the result contains strings with commas, the commas are treated wrongly as field delimiters. And if the result contains double quotes, they are wrongly treated as escape characters.
The "Download CSV" option doesn't do any escaping, so if the result contains strings with commas, the commas are treated wrongly as field delimiters. And if the result contains double quotes, they are wrongly treated as escape characters.
November 22, 2024 at 6:05 PM
I'm very impressed!
Not only that this issue with @OracleLiveSQL was fixed shortly after I had reported about it. I also got mails from the developer when she started working on it, finished, and applied the fix in production.
Well done 👍
Thank you 🙂
/cc @mikehichwa1 @oracleace
Not only that this issue with @OracleLiveSQL was fixed shortly after I had reported about it. I also got mails from the developer when she started working on it, finished, and applied the fix in production.
Well done 👍
Thank you 🙂
/cc @mikehichwa1 @oracleace
Just sent a feedback to @OracleLiveSQL:
The "Download CSV" option doesn't do any escaping, so if the result contains strings with commas, the commas are treated wrongly as field delimiters. And if the result contains double quotes, they are wrongly treated as escape characters.
The "Download CSV" option doesn't do any escaping, so if the result contains strings with commas, the commas are treated wrongly as field delimiters. And if the result contains double quotes, they are wrongly treated as escape characters.
November 22, 2024 at 5:56 PM
Just sent a feedback to @OracleLiveSQL:
The "Download CSV" option doesn't do any escaping, so if the result contains strings with commas, the commas are treated wrongly as field delimiters. And if the result contains double quotes, they are wrongly treated as escape characters.
The "Download CSV" option doesn't do any escaping, so if the result contains strings with commas, the commas are treated wrongly as field delimiters. And if the result contains double quotes, they are wrongly treated as escape characters.
Is it just me, or @OracleLiveSQL is down?
November 22, 2024 at 4:28 PM
Is it just me, or @OracleLiveSQL is down?
Congrats on @oraclelivesql launch! Very cool site. 1st feedback - nice to have short links to scripts - makes it easier to share, etc.
November 18, 2024 at 11:21 PM
Congrats on @oraclelivesql launch! Very cool site. 1st feedback - nice to have short links to scripts - makes it easier to share, etc.
Always cool to see universities using @OracleDatabase and @OracleLiveSQL for teaching their students proper database and SQL skills!
November 13, 2024 at 3:04 PM
Always cool to see universities using @OracleDatabase and @OracleLiveSQL for teaching their students proper database and SQL skills!
I made my first @OracleLiveSQL tutorial using @pilatesdev handiwork
can't wait to make the new interface avail to everyone that wants to learn, live, breath SQL!
can't wait to make the new interface avail to everyone that wants to learn, live, breath SQL!
November 12, 2024 at 1:44 PM
I made my first @OracleLiveSQL tutorial using @pilatesdev handiwork
can't wait to make the new interface avail to everyone that wants to learn, live, breath SQL!
can't wait to make the new interface avail to everyone that wants to learn, live, breath SQL!