LiveSQL @OracleLiveSQL

Get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. #livesql livesql.oracle.com Redwood City, CA Joined August 2015

Tweets

94
Followers

2K
Following

69
Likes

57

layla @pilatesdev

4 months ago

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 8K 21

View Details

layla @pilatesdev

6 months ago

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 3K 1

View Details

Oracle Developers @OracleDevs

7 months ago

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 3K 8

View Details

Oracle Developers @OracleDevs

7 months ago

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 2K 5

View Details

layla @pilatesdev

7 months ago

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 5K 14

View Details

layla @pilatesdev

7 months ago

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…

7 14 140 19K 73

View Details

layla @pilatesdev

8 months ago

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…

0 4 24 4K 0

View Details

LiveSQL @OracleLiveSQL

8 months ago

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_3w0…

0 0 2 210 0

View Details

LiveSQL @OracleLiveSQL

8 months ago

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 2K 6

View Details

layla @pilatesdev

8 months ago

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 31 3K 5

View Details

layla @pilatesdev

8 months ago

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 3K 8

View Details

LiveSQL @OracleLiveSQL

2 years ago

we're SO back 😎

0 2 37 9K 1

View Details

LiveSQL @OracleLiveSQL

2 years ago

@pilatesdev 😎😎⚡️

0 0 2 254 0

View Details

Oracle AI Database @OracleDatabase

7 years ago

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 0 1

View Details

Oracle Developers @OracleDevs

7 years ago

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 0 6

View Details

LiveSQL @OracleLiveSQL

7 years ago

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

1 18 39 0 1

View Details

LiveSQL @OracleLiveSQL

8 years ago

@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