This content has been marked as final. Show 1 reply
It can't. Oracle TDE encrypts data at the OS file level. It protects data from someone directly accessing the data files. You need to have an Oracle wallet and if you don't you'll get something like "ORA-28365: wallet is not open" when trying to access encrypted data. What you are describing can be done with something like DBMS_CRYPTO:
You'll need to encrypt the data on on insert (and update) and then decrypt it when read. It's good that you are working on encrypting data. It's a valuable skill.