Daylight saving is ending across Europe and North America But they change on different dates! To see when the continents are an hour closer, Kim Berg Hansen built a pattern-matching query comparing the TIMEZONE_HOUR for dates across the year kibeha.dk/2025/10/dst-di…

Developers are inundated with tools that are meant to help their work, but often lead to frequent context switching. In the age of AI, agents could be the solution to developers' distraction problem. Ryan Donovan examines AI as a unifying interface, and what it might take for

🎙️ Tom Moor, head of engineering at Linear, joins the pod to discuss AI agents’ mixed results for productivity, the importance of context for maximizing their effect, and the role that junior devs should take in a world increasingly driven by AI. stackoverflow.blog/2025/10/28/cra…

Oracle AI Database has several string similarity functions SOUNDEX PHONIC_ENCODE - double metaphone FUZZY_MATCH - several algorithms, including Jaro-Winkler & Levenshtein Brendan Tierney compares how they encode spelling variations of Brendan oralytics.com/2025/10/15/com…

💡 Wondering how to let users choose between different authentication methods in your Oracle APEX application? Multi-authentication is the answer! This new blog breaks it down step-by-step. 👉 Read the blog post to learn more: social.ora.cl/60117HzJx #orclAPEX #LowCode

Storing UUIDs as RAW values is more efficient than strings But RAW can lead to implicit conversions => poor row estimates If you're stuck with string comparisons Andrej Pashchenko 🇺🇦 💙💛 shows how to improve row estimates with Extended stats Virtual columns blog.sqlora.com/en/fix-optimiz…

الف مبروك لأهلنا في #الشارقة

The KEEP clause - aka FIRST/LAST functions - in Oracle #SQL enables you to get the min/max row for one column sorted by another MIN ( sal ) KEEP ( DENSE_RANK FIRST ORDER BY hire ) => Get the lowest sal for the first hire Quanwen Zhao explores quanwenzhao.wordpress.com/2025/10/15/ora…

Oracle wins the multilingual text-to-SQL Archer Challenge by combining planning and #SQL agents Understanding Archer queries requires Arithmetic reasoning Commonsense inference Hypotheticals and counterfactuals Bilingual execution (English + Chinese) blogs.oracle.com/cloud-infrastr…

Click, click and voila! You're connecting from your own machine!

🆕 Customer Success Story! 💡 From planning to execution: the VAN group achieved much more efficient and connected logistics operations by modernizing its Transportation Management System with Oracle APEX. Check out the full story social.ora.cl/60127Pc1A #orclAPEX #LowCode

Poorly written #SQL can lead to slow, hard-to-maintain queries Jordan Goodman covers common anti-patterns you should avoid, including Case expressions instead of tables Functions on indexed columns Overusing DISTINCT to “fix” duplicates datamethods.substack.com/p/sql-anti-pat…

More SQL Dev goodies awaiting in this update marketplace.visualstudio.com/items?itemName…

Want to find the fastest-growing tables or LOBs in Oracle AI Database? Marcus Vinicius has built a script that analyzes AWR data to show The 20 segments with the largest total size increases A breakdown of the increase per month for each Get it at github.com/vinidba/dba_sc…

Oracle Virtual Private Database enables you to transparently add WHERE clauses to restrict what users can see See what was added with DBMS_UTILITY.EXPAND_SQL_TEXT But this may expose sensitive values! Connor on SQL and Database shows how to hide them with contexts connor-mcdonald.com/2025/10/15/sec…

Get free access to Oracle AI Database at freesql.com This browser-based tool enables you to run and share #SQL statements Even better, you can now connect to your schema from clients on your machine using SQL*Net So you can run SQL from your favourite IDE

We have big news: Stack Internal is now live! 🚀 Formerly known as Stack Overflow for Teams, Stack Internal is the evolution of our enterprise intelligence system built for modern engineering teams, made powerful by Knowledge Ingestion, our bidirectional MCP Server, and the

Want to find the Nth highest value in a table? e.g. the 3rd highest salary/department? Number the values with DENSE_RANK () OVER ( PARTITION BY ... ORDER BY ... DESC ) Then filter where the output of this is 3 Manish Sharma 👉SQL & Database demos youtube.com/watch?v=Pg4ox7…

SQL is not just great at analyzing your data, it can also be used to analyze hypothetical scenarios where you do NOT have data. youtu.be/AJNUidMKMSg

Oracle AI Database 23.26.0 developer features include QUALIFY clause GraphQL Table Function for SQL SQL Objects and Collections in MLE JavaScript PL/SQL RESETTABLE clause to avoid ORA-04068: existing state of packages has been discarded Gerald Venzl 🚀 geraldonit.com/whats-new-for-…