Which Column has Changed in Every Row? Mustafa Kalaycı, 2020-11-02 Hi, Edit: Thanks to Chris Saxon who is from asktom team, checked my code and warned me about a problem. Not to overload the PGA fetch_rows function only fetches 1024 rows at once so every row set chunk size is 1024. In this case for the 1025th row, previous row… Continue Reading
SQL Macro Part2 column_value = nvl(:param, column_value) Mustafa Kalaycı, 2020-10-30 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