
LiveSQL
@OracleLiveSQL
Get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. #livesql
Potrebbero piacerti
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 Tendenze
- 1. #DWTS 36.4K posts
- 2. Yamamoto 21.1K posts
- 3. #DWCS 6,788 posts
- 4. Ohtani 12.6K posts
- 5. #WWENXT 16.8K posts
- 6. #Dodgers 13.3K posts
- 7. Robert 104K posts
- 8. Carrie Ann 4,329 posts
- 9. Haji Wright N/A
- 10. #RHOSLC 3,906 posts
- 11. Roldan 2,310 posts
- 12. Brewers 36.3K posts
- 13. Young Republicans 55.8K posts
- 14. Elaine 57K posts
- 15. Whitney 14.9K posts
- 16. Max Muncy 3,877 posts
- 17. Yelich 1,595 posts
- 18. Dylan 32.3K posts
- 19. Politico 273K posts
- 20. Mr. Feeny 1,596 posts
Potrebbero piacerti
-
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.