Pragma UDF & Deterministic

Hello everyone, I wanted to write about something simple and can improve the performance of your sql statements. Unfortunately, many database developers use too much plsql function in their SQL statements. I say too much because if you learn more about the SQL, you will use less plsql. SQL is very capable language to process

SQL Macro Part2 column_value = nvl(:param, column_value)

Hi, Since I am working on “SQL Macro”, I am keep testing things. so please see my previous post: 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 a very cumbersome solution in