Simple question, but, probably no a simple answer:
Using the HR schema that comes with Oracle samples as examples, I would like to redact the employees.salary, but I want the the amount be always returned using a custom functions.
example, King salary on the table is 24000 … I want to use a specific function, let say value = salary/*2+10/5 … so all times will returned a redact value with the same information. I don't want a random number it time I access the salary, also I don't want to mask the amount, doing update on the table.
Any idea?