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

Joined August 2015
19 Photos and videos
Pinned Tweet
30 Sep 2025
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
1
7
8
2,011
LiveSQL retweeted
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 ๐Ÿ‘‡
5
10
55
8,507
LiveSQL retweeted
16 Dec 2025
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 :-)
2
4
14
2,813
LiveSQL retweeted
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)
1
9
23
2,569
LiveSQL retweeted
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
1
6
25
2,433
LiveSQL retweeted
13 Nov 2025
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
4
4
71
5,171
LiveSQL retweeted
7 Nov 2025
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-conneโ€ฆ
7
14
141
18,769
LiveSQL retweeted
9 Oct 2025
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/librโ€ฆ
4
24
3,906
30 Sep 2025
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
1
7
8
2,011
30 Sep 2025
Curious about whatโ€™s new in LiveSQL v2? ๐Ÿช„ Our dev & PM @pilatesdev walks you through the fresh UI, features, and workflow. ๐Ÿ‘‰Watch the video: youtube.com/watch?v=dP_3w0d7โ€ฆ
2
210
LiveSQL retweeted
29 Sep 2025
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
2
4
30
3,358
LiveSQL retweeted
30 Sep 2025
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!
1
5
22
3,351
we're SO back ๐Ÿ˜Ž
2
37
8,842
LiveSQL retweeted
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! apex.oracle.com/autonomous #orclapex
1
39
53
LiveSQL retweeted
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! apex.oracle.com/autonomous #orclapex
3
66
93
16 Jan 2019
We're now running LIVE with @OracleDatabase 19c! #oracle #database #19c
1
18
39
28 Aug 2018
@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! livesql.oracle.com #SQL #Database
2
23
59
LiveSQL retweeted
Something like 18.0 or 18.1 is there on @oraclelivesql :)
1
3
11
Oracle Database 18c Released : How to Get Started : oracle-base.com/blog/2018/02โ€ฆ
42
75
17 Feb 2018
In case you missed it... 18c, now available for you to learn and try...here. Thanks @connor_mc_d @chrisrsaxon for all of the new 18c scenarios/scripts for everyone to check out! #Oracle #Database #SQL
24
26
LiveSQL retweeted
Itching to start playing with 18c? Now you can on @oraclelivesql ! Here's a script to get you started: a dynamic CSV-to-columns converter using polymorphic table functions livesql.oracle.com/apex/oracโ€ฆ
3
31
54