Row Versioning
I have 250 tables starting with TBL and another copy of same tables starting with HST (history) in a Schema. all TBL (Source) tables needs to maintain a history of transations in a HST (history) tables. all the Insert, Update and Delete on main table should be recorded in history tables. what is the best way to solve this requirement?