I've come across many kinds of data masking techniques used in Oracle database.. some are licensed some are included in enterprise edition itself.. leaving the licenses thing behind as it is restricted to ask about it here..
I would like to know what is the difference between
Transparent Data Encryption
Virtual Private Database
Oracle Label Security
Data Masking pack
Ultimately each one of the above does the same job - mask the data right?
What are the differences between them??
If data masking pretty much only overwrites the data which I actually need to mask, won't a simple SQL update statement do that trick on a particular table? Why buy a tool for that?