#LiveSQL
LightNews LightNews
thatjeffsmith.com
I have a new answer for what's the easiest way to get started with Oracle or SQL, using the latest technology..

Oracle LiveSQL

www.thatjeffsmith.com/archive/2024...
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
It's that much easier to get started learning SQL and Oracle Database with our new and improved Oracle LiveSQL platform! Now running 23ai!
www.thatjeffsmith.com
November 18, 2024 at 9:01 PM
sqlmaria.com
Mike Hitchwa just demoed the new version 2 of #oracle LiveSQL which is really cool Chrck it out at livesql.oracle.com
December 10, 2024 at 6:10 PM
loiclefevre.bsky.social
Wow, LiveSQL v2 is finally here!!!

#SQL #Easy #Tutorials
krisrice.io Kris Rice @krisrice.io · Nov 18
The new Oracle Live SQL is here. This is essentially a SQL Fiddle to learn. This ground up rewrite around SQL Developer web and Oracle REST Data Services.
It comes with an increase in schema life from 8 hours to 90 days! Check it out with the Try V2 link on the home page. livesql.oracle.com
November 18, 2024 at 8:09 PM
thatjeffsmith.com
Recording from yesterday's Oracle Database & Cloud news update with @krisrice.io

www.thatjeffsmith.com/archive/2025...
Database News: June edition. 23ai and some LiveSQL
Summary from our Oracle Developer Coaching, June News Edition. Kris and I were back to talk more things Oracle Database and LiveSQL!
www.thatjeffsmith.com
June 11, 2025 at 1:04 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
December 4, 2025 at 9:38 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
March 17, 2026 at 8:41 PM
domgiles.bsky.social
Great news… LiveSQL for the #oracle database was amazing. V2 is a big step forward with so much more to come.
November 19, 2024 at 7:31 AM
martindba.bsky.social
Have you heard about Oracle LiveSQL yet? It's the easiest way to access the Oracle database engine to run SQL, PL/SQL and now JavaScript. The JavaScript part in particular is interesting, and since it's new, I wrote a short blog post about it. martincarstenbach.com/2025/07/29/l...
LiveSQL supports MLE/JavaScript 🎉
Oracle LiveSQL allows you to learn and share SQL, for free. You get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. You can write your own SQL …
martincarstenbach.com
July 29, 2025 at 2:15 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
September 28, 2025 at 4:40 AM
krisrice.io
Sharing Code w/ LiveSQL www.linkedin.com/pulse/sharin...
Sharing Code w/ LiveSQL
Unlock the Power of Oracle Database with LiveSQL: Fast, Free, and Feature-Rich If you’re looking to dive into Oracle Database without the hassle of installation or setup, LiveSQL.oracle.
www.linkedin.com
June 11, 2025 at 4:34 PM
thatjeffsmith.com
Tech at #oracle I 'own':
database tools - SQL Developer, Data Modeler, REST Data Services (ORDS), SQLcl, VS Code extensions, SQL Developer Web, OCI Database Tools Services, OCI DocGen (PDFs), Oracle LiveSQL, and our VirtualBox 23ai appliance.

❓: What can I do/share here to best help YOU
October 29, 2024 at 2:17 PM
thatjeffsmith.com
Some nice 23ai demo SQLs showing
CREATE IF NOT EXISTS
DOMAINS
JSON RELATIONAL DUALITY VIEWS
ANNOTATIONS
BOOLEAN
MULTI-ROW INSERTs

www.thatjeffsmith.com/archive/2024...

And now testing & working on LiveSQL :) Just copy and paste the code and go!
November 19, 2024 at 5:33 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Database News: June edition. 23ai and some LiveSQL
Database News: June edition. 23ai and some LiveSQL
Previously on @thatjeffsmith... Database News: June edition. 23ai and some LiveSQL
www.thatjeffsmith.com
September 27, 2025 at 4:37 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Database News: June edition. 23ai and some LiveSQL
Database News: June edition. 23ai and some LiveSQL
Previously on @thatjeffsmith... Database News: June edition. 23ai and some LiveSQL
www.thatjeffsmith.com
August 23, 2025 at 12:38 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
July 21, 2026 at 12:36 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
May 2, 2026 at 8:37 PM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
April 18, 2026 at 12:36 PM
connormcd.bsky.social
Heads up for long term LiveSQL users:
January 8, 2026 at 6:36 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
October 23, 2025 at 12:38 PM
thatjeffsmith.com
SQL Developer Web, Database Actions, LiveSQL - these web applications are powered by REST APIs.

Each request you make is ran as it's own transactions/session.

To test 23ai's SQL Transpiler, run it as a script!

Hat Tip: @monikalewandowska.bsky.social
Learn more: oracle-base.com/articles/23/...
alter session set sql_transpiler = 'ON'; select id, val1, val2 from t1 where add_numbers(val1, val2) = 300; EXPLAIN PLAN FOR select id, val1, val2 from t1 where add_numbers(val1, val2) = 300; select plan_table_output from table(dbms_xplan.display('plan_table',null,'all'));
November 20, 2024 at 8:08 PM
shortribninja1.blacksky.app
x.com/pilatesdev/s... definitely going to play in this next week
layla on X: "LiveSQL is your new SQL bestie - allowing you to learn, write and execute SQL all in your browser, with ZERO database setup or installations! (& did I mention it's free???) 😝 https://t.co/JTohJhVgxf" / X
LiveSQL is your new SQL bestie - allowing you to learn, write and execute SQL all in your browser, with ZERO database setup or installations! (& did I mention it's free???) 😝 https://t.co/JTohJhVgxf
x.com
September 14, 2025 at 2:14 AM
cczarski.bsky.social
... seen the usage of REGEXP_SUBSTR and CONNECT BY to tokenize strings with SQL - and guess what? Was way too slow.

So, here's a LiveSQL V2 script to compare a few approaches.
livesql.oracle.com/next/library...

JSON_TABLE or APEX_STRING are still my favorites!

#OracleDatabase #SQL
Live SQL V2 script to show how delimited strings can be tokenized in the Oracle Database. My favorites are: -- -- Alternative 1: Split with APEX_STRING.SPLIT -- select record_id, count(column_value) as token_cnt from tokens, apex_string.split( record_tokens, ':') group by record_id; -- -- Alternative 2: Split with JSON_TABLE -- select record_id, count(token) as token_cnt from tokens, json_table( '["' || replace( replace( replace( record_tokens, '\', '\\' ), '"', '\"' ), ':', '","' ) || '"]', '$[*]' columns (token varchar2(255) path '$' )) group by record_id;
November 26, 2024 at 2:43 PM
quanwenzhao.bsky.social
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
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
jloracle.bsky.social
Oracle optimizer is a little buggy when handling subquery coalescing - various failures and wrong results reported on MOS since 12.1.0.1, still breaking (in some cases) in 23ai (LiveSQL).
Example (with suggested hacks) on the Oracle forums:
forums.oracle.com/ords/apexds/...
forums.oracle.com
March 14, 2025 at 10:31 AM
thatjeffsmith.com
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
Previously on @thatjeffsmith... Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
www.thatjeffsmith.com
September 15, 2026 at 4:36 AM