2 of Most Practical New Features on 23.9 Mustafa, 2025-08-09 Hi, with 23.9 I saw 2 beautiful enhancement in SQL. These are not “exceptional” things but their practical usage is a lot to me as a both developer and dba. 23.9 is already available on cloud base database systems. First, INSERT SET is here! one of my biggest complains in… Continue Reading
23c is Finally Here! Mustafa, 2023-04-06 Hello everyone, Well, it is just developer version so don’t try to install on your environments 🙂 My twitter is full of 23c tweets about these days. I also downloaded immediately and tested what I wanted the most for 4-5 years! “Schema Level Privileges” and I am so excited about… Continue Reading
SQL Macro Part2 column_value = nvl(:param, column_value) Mustafa, 2020-10-302021-09-23 Hi, Since I am working on “SQL Macro”, I am keep testing things. so please see my previous post: https://mustafakalayci.me/2020/10/28/sql-macro-is-finally-here/ as mentioned in previous post, is it possible to get rid of column_value = nvl(:param, column_value) conditions? since they become a huge pain in big and complex queries. I provided… Continue Reading