LiveSQL

Get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. #livesql

[LiveSQL @OracleLiveSQL]

LiveSQL v2 is here — faster, cleaner, smarter 🏆
✔️ Powered by @Oracle Database 23ai
✔️ Run SQL instantly in your browser (no installs, no sign-ups)
✔️ Explore scripts & tutorials from the community
✔️ Fresh UI + improved developer experience
Try it now → https://t.co/5HSGkxYv1D

[layla @pilatesdev]

FreeSQL just got a lot more powerful, y'all

You can now connect a real @OracleDatabase directly to your local tools using SQL*Net. That means VS Code, SQLcl, SQL Developer, Python, and Node all connect to the same hosted database :)

Free, zero setup, and SUPER useful for building real full-stack apps 👇

[layla @pilatesdev]

Ok, this is my FAVE feature on FreeSQL so far:
our new SQL*Net connection lets you move between FreeSQL 𝒂𝒏𝒅 VS Code with the 𝑠𝑎𝑚𝑒 schema and data 🤌🏽

Copy your SQLcl details → connect via terminal → query your data → back to FreeSQL to verify

Check out the flow :-)

[Oracle Developers @OracleDevs]

Relational and JSON in one model? 🤯

With Oracle Database 26ai, you can use relational tables AND JSON documents together—the same data, perfectly synced, no duplications. Learn more in this hands-on lab: https://t.co/Z6yhHU6NIK (via @pilatesdev)

[Oracle Developers @OracleDevs]

Explaining ROW_NUMBER, RANK, and DENSE_RANK in SQL can leave your audience yawning. 😴

Enter @pilatesdev, who built a simple leaderboard in FreeSQL that brought instant clarity on how the ranking functions behave. Practice SQL ranking functions using her Leaderboard Demo tutorial in FreeSQL: https://t.co/kMtUPDdBS9

[layla @pilatesdev]

hi from your friendly neighborhood @oracle FreeSQL dev + PM! 👩🏽‍🔧

we just shipped a new feature on FreeSQL called SQL*Net :) you can now connect to your FreeSQL schema from any local tool, like VsCode, Python, SQLcl, or anything you prefer!

read more about it below

[layla @pilatesdev]

NEW feature on https://t.co/l6Y75yWl1h 🪄

Connect your FreeSQL schema from any local tool using SQL*Net: VS Code, SQLcl, SQL Developer, Python, Node.js, you name it!

Write SQL in your favorite tool, all backed by Oracle Database ⚡

How to get started 👇
https://t.co/AKkVNQt0JK

[layla @pilatesdev]

You ever hit Run and just smile at your output? :’) That’s when you realize how overcomplicated your old SQL was -- one line with SUM() OVER (ORDER BY sale_date) does the work of ten, and it’s so satisfying to watch it execute!

Instead of juggling nested subqueries for running totals, window functions handle it in one clean sweep. No self-joins, no CTE gymnastics -- just clean, readable results that tell a story row by row 😗🤌🏽

🪄 Try my Running Totals Demo in LiveSQL: https://t.co/IyhIxf0HdH

[LiveSQL @OracleLiveSQL]

Curious about what’s new in LiveSQL v2? 🪄

Our dev & PM @pilatesdev walks you through the fresh UI, features, and workflow.
👉Watch the video: https://t.co/lw3RBttJ2u

[LiveSQL @OracleLiveSQL]

LiveSQL v2 is here — faster, cleaner, smarter 🏆
✔️ Powered by @Oracle Database 23ai
✔️ Run SQL instantly in your browser (no installs, no sign-ups)
✔️ Explore scripts & tutorials from the community
✔️ Fresh UI + improved developer experience
Try it now → https://t.co/5HSGkxYv1D

[layla @pilatesdev]

Ever tried explaining the difference between ROW_NUMBER, RANK & DENSE_RANK in SQL?

Usually takes boring slides 🤮 I ran a quick leaderboard demo in LiveSQL -- 3 lines of SQL, instant clarity on how the ranking functions behave!!

Try it yourself, no setup needed! Link below

[layla @pilatesdev]

SQL INNER JOINs return matches only; LEFT JOINs also return the unmatched left rows. We all know the textbook definitions, but the real learning happens when you SEE it 😗🤌🏽

I ran both queries in @OracleLiveSQL, with zero setup in the browser. Try my JOINS demo, link below!

[LiveSQL @OracleLiveSQL]

we're SO back 😎

[LiveSQL @OracleLiveSQL]

@pilatesdev 😎😎⚡️

[Oracle AI Database @OracleDatabase]

What can you do with Oracle Autonomous Database and #LowCode?

With @OracleAPEX and @OracleREST, you can:

✅ reduce costs
✅ deliver solutions faster
✅ provide rich functionality
✅ develop and deploy world class apps
✅ bonus: become a hero!

https://t.co/w4MNfXAyLv

#orclapex

[Oracle Developers @OracleDevs]

Announcing the immediate availability of APEX, ORDS, and SQL Dev Web on Autonomous Database Cloud!

Unparalleled functionality combined into a single self-driving platform.

@OracleREST + @OracleAPEX + Autonomous @OracleDatabase = Awesome!

https://t.co/1rgLCUN2Ta

#orclapex

[LiveSQL @OracleLiveSQL]

We're now running LIVE with @OracleDatabase 19c!

#oracle #database #19c

[LiveSQL @OracleLiveSQL]

@OracleLiveSQL is now running #orclapex 18.1 + the latest version of Universal Theme!

We've also streamlined the #UX making it far simpler to use!

Get free and instant access to @OracleDatabase 18c and over 800+ scripts and tutorials!

https://t.co/732MFKxBTz

#SQL #Database

[LiveSQL @OracleLiveSQL]

@connor_mc_d @kidrac @FranckPachot Sharing is caring.

[Franck Pachot @FranckPachot]

Something like 18.0 or 18.1 is there on @oraclelivesql :)

[Tim Hall ∞🐵+∞⌨️ @oraclebase]

Oracle Database 18c Released : How to Get Started : https://t.co/lz0bUKO04C