Transparent Data Encryption
We are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database.
we have used the below query for creating a table with encrpted column, but when we try to retrive the data using sql or ORDS its behaving as ordinary column & giving the data as it is.
CREATE TABLE employee (
salary NUMBER(6) ENCRYPT)
kindly let us know if am doing anything wrong.We are refering to the below blogs for TDE.