I have 200+ columns whose data needs to be replaced with some random values i.e. mask the data.
The length of data type usually -varchar.
My query looks like - where column1 is being masked.
where len(column1) > 30
How do I make function (or something else )to make it more generic so that I can pass column, schema and table name more generically?
(since they all will change)
or is it worth making one?
Thanks for help