I am looking to mask the data(Columns) in the existing table without creating a new table and sensitive data(Columns) like Name, Mailid, phone number etc...
Can someone help me with the query.
Lets think we have a table(Empsal) with columns name mobile no ID salary department
Now I want to mask the complete data in the columns mobileno,Name,ID
Can someone help me with the SQL query without creating a new data this table already exists in the database and need to do masking for the existing table.