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: http://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 a very cumbersome solution in

Flashback Data Archive Problems!

Hi, if you don’t know about flashback data archive you can check this post first: http://mustafakalayci.me/2019/03/02/goodbye-log-triggers-welcome-flashback-data-archive/ I mentioned about flashback data archive (FDA) in that post and really flattered it. Well, maybe I shouldn’t! FDA is really fast dml tracking method but thanks to Peter Schlaeger, I noticed some potential problems and “some” solutions. Few

Control File Content and the Limits

Hi, I would like to talk about Control File (CF). One of the most important component of the Oracle Database. It stores many critical data and limits for the database. Last SCN (System Change Number). Last Checkpoint Information. Data file locations. Redo log file locations. RMAN Repository (where the backup related files are). Parameters like