
Get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. #livesql
Redwood City, CA
Joined August 2015
- Tweets93
- Following69
- Followers2.5K
- Likes55
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 👇
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 :-)
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 @layluh)
LiveSQL retweeted
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
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
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…
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…
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
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!
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 – at Seattle, WA
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
LiveSQL retweeted
Something like 18.0 or 18.1 is there on @oraclelivesql :)
LiveSQL retweeted
Oracle Database 18c Released : How to Get Started : oracle-base.com/blog/2018/02…
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…
LiveSQL retweeted
The more I use @oraclelivesql the more I like it and SQL
LiveSQL retweeted
Want to go from SQL to PLSQL? Give @oraclelivesql a look-see. stackoverflow.com/a/48666313…
LiveSQL retweeted
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 😉
LiveSQL retweeted
Right in time for #OOW16 – Oracle Application Express 5.1 EA-2 now live, sign up: apexea.oracle.com #orclapex





















