LiveSQL

94 posts

LiveSQL banner
LiveSQL

LiveSQL

@OracleLiveSQL

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

Redwood City, CA Katılım Ağustos 2015
69 Takip Edilen2.5K Takipçiler
Sabitlenmiş Tweet
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 → livesql.oracle.com/next
LiveSQL tweet mediaLiveSQL tweet mediaLiveSQL tweet mediaLiveSQL tweet media
English
1
7
8
2K
LiveSQL retweetledi
layla
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 👇
English
5
10
56
8.5K
LiveSQL retweetledi
layla
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 :-)
English
2
4
14
2.8K
LiveSQL retweetledi
Oracle Developers
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: social.ora.cl/60187KOJo (via @pilatesdev)
English
1
9
23
2.6K
LiveSQL retweetledi
Oracle Developers
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: social.ora.cl/60147KO1i
Oracle Developers tweet media
English
1
6
25
2.4K
LiveSQL retweetledi
layla
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 tweet media
English
4
4
72
5.1K
LiveSQL retweetledi
layla
layla@pilatesdev·
NEW feature on FreeSQL.com 🪄 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 👇 linkedin.com/pulse/how-conn…
layla tweet media
English
7
14
143
18.7K
LiveSQL retweetledi
layla
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: livesql.oracle.com/next/library/t…
GIF
English
0
4
24
3.9K
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 → livesql.oracle.com/next
LiveSQL tweet mediaLiveSQL tweet mediaLiveSQL tweet mediaLiveSQL tweet media
English
1
7
8
2K
LiveSQL retweetledi
layla
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
GIF
English
2
4
31
3.3K
LiveSQL retweetledi
layla
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!
layla tweet media
English
1
5
24
3.3K
LiveSQL
LiveSQL@OracleLiveSQL·
we're SO back 😎
English
0
2
37
8.8K
layla
layla@pilatesdev·
I’m taking over the @OracleLiveSQL account!! Will be posting tons of content leading up to the release of LiveSQL soon - go follow :)
layla tweet media
Austin, TX 🇺🇸 English
23
15
677
34.4K