🎉 Oracle Database@AWS Now Generally Available – Oracle announced the General Availability of Oracle Database on AWS.
📰 Mixed Feelings About MERGE – DBoriented talks about his “like-dislike” relationship with the MERGE statement and demonstrates some of the statement’s nuances.
📰 SQL Plus and SQLcl Formatation Tip for Macbook users – Maicon Carneiro highlights a productivity tip for copy/pasting SQL prompt outputs.
📰 Better support for JavaScript’s console.log() in ORDS handlers – Martin Bach demonstrates Oracle REST Data Services’ better handling of JavaScript console.log().
📰 “Is That Column Indexed?” – David Fitzjarrell shares a script that determines what indexes are created against a given table and how those indexes are built.
📰 Oracle database predicate mistakes – 23ai SQL Analysis Report – Gary Gordhamer demonstrates the new 23ai SQL Analysis Report feature.
📰 Reading and writing files on Amazon S3 from Oracle Autonomous Database and PL/SQL – Niall Mc Phillips shows how you can manipulate files on an AWS S3 bucket directly via PL/SQL in Autonomous Database.
📰 Accidentally Set ORACLE_MAINTAINED=Y — Now What? – Vinicius shows the implication of ORACLE_MAINTAINED=Y, why you should be very careful of setting an underscore parameter and how you should most likely not change your schema to ORACLE_MAINTAINED=N.
📰 Deadlock within DML statements – David Kurtz dives deeper into Deadlocks and shows how they come about.