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

Redwood City, CA
Joined August 2015
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
8
54
8,722
LiveSQL retweeted
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,972
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 @layluh)
1
9
22
2,603
Explaining ROW_NUMBER, RANK, and DENSE_RANK in SQL can leave your audience yawning. 😴 Enter @layluh, 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
7
25
2,469
LiveSQL retweeted
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
70
5,317
LiveSQL retweeted
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
12
1
137
18,984
LiveSQL retweeted
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,976
LiveSQL retweeted
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,418
LiveSQL retweeted
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,463
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 – at Seattle, WA
1
37
2
52
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
65
6
93
Something like 18.0 or 18.1 is there on @oraclelivesql :)
1
3
1
11
Oracle Database 18c Released : How to Get Started : oracle-base.com/blog/2018/02…
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
The more I use @oraclelivesql the more I like it and SQL
1
4
Want to go from SQL to PLSQL? Give @oraclelivesql a look-see. stackoverflow.com/a/48666313…
1
3
3
I needed a quick example for JSON_TABLE, and I found one on @oraclelivesql. Thanks for authoring this @wileecoyote_! livesql.oracle.com/apex/live…
LiveSQL retweeted
it’d be nice if it was hosted on livesql.oracle.com #oraclecode 😉
1
1
1
Right in time for #OOW16 – Oracle Application Express 5.1 EA-2 now live, sign up: apexea.oracle.com #orclapex
Outstanding new version of @Oracle Learning Library (on APEX 5!) #orclapex oracle.com/goto/oll