LiveSQL
@OracleLiveSQL
Get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. #livesql
You might like
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
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…
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
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!
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
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
@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
Oracle Database 18c Released : How to Get Started : oracle-base.com/blog/2018/02/1…
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
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/oracle_li…
Learn new 12c and 12cR2 concepts here! A quick play with Approximate Query Processing, test case courtesy @oraclebase oracle-base.com/articles/12c/a… #Oracle #SQL
How to find consecutive rows with #SQL via @chrisrsaxon livesql.oracle.com/apex/f?p=590:4… #Oracle
Want to go from SQL to PLSQL? Give @oraclelivesql a look-see. stackoverflow.com/a/48666313/115…
Yes, we can help you with your homework! Run your @oracledatabase queries/scripts directly in your browser, nothing to install.
Our own @chrisrsaxon has a nice series of DATE queries to work through here a well livesql.oracle.com/apex/livesql/f…
New to @OracleDatabase and SQL? Today's homework: read up on dates and NLS_DATE_FORMAT oracle-base.com/articles/misc/…
United States Trends
- 1. Bears 89.8K posts
- 2. Jake Moody 13.7K posts
- 3. Snell 24.5K posts
- 4. Caleb 49.6K posts
- 5. Bills 143K posts
- 6. Falcons 51.5K posts
- 7. Jayden 23K posts
- 8. Josh Allen 26.7K posts
- 9. phil 177K posts
- 10. Happy Birthday Charlie Kirk 4,893 posts
- 11. #BearDown 2,383 posts
- 12. Swift 291K posts
- 13. Joji 30.3K posts
- 14. Ben Johnson 4,453 posts
- 15. Turang 4,335 posts
- 16. #Dodgers 15.4K posts
- 17. Troy Aikman 6,559 posts
- 18. Roki 6,135 posts
- 19. Bijan 33K posts
- 20. AFC East 11K posts
You might like
-
Ask TOM for Database/SQL
@OracleAskTOM -
Maria Colgan
@SQLMaria -
krisrice 🏒🍺📷
@krisrice -
Dimitri Gielis
@dgielis -
Jorge Rimblas
@rimblas -
Dan McGhan
@dmcghan -
Scott Spendolini🍊
@sspendol -
Patrick Wolf
@patrickwolf -
Marc Sewtz
@msewtz -
@APEX/JeffreyKemp.sql
@jeffreykemp -
Dietmar Aust
@daust_de -
Martin Giffy D'Souza
@martindsouza -
SQL Daily
@sqldaily -
Oliver Lemm
@OliverLemm -
Przemysław Staniszewski
@pstaniszewski
Something went wrong.
Something went wrong.