How I can mask a column in a table and still search on it, but not see it
We have a business need, where we need to mask (hide) a particular column in the table, but still be able to search on that column with a valid value.
So say, I have column A,B,C in a table called TEST, column B is varchar2
I need to be able to do run the following query:
select * from TEST where B='EG' ; (WHERE EG is a valid value), but not see the column B
or do
select * from TEST ; (not see the value of column
or do
select * from TEST where B like '%12%'; (not see the values in column