1 person found this helpful
Depending on your database version, DBMS_CRYPTO will do the trick.
There are plenty of examples out there on how to use packages like this to solve the requirement you describe.
Thanks for this. Do you know of an example where this function has been called from an APEX application? - I'm ideally looking for a step by step guide from an APEX point of view suitable for a relative novice in APEX
Try these documents:
The features you request are Database Features.
You could use DBMS_CRYPTO for data encryption instead of TDE, but you will have to create a package for your insert,update, deletes along with a view that allows decryption based on v('APP_USER').
Also, you won't be able to search on that column if you use DBMS_CRYPTO.
MIke & Scott
Many thanks for your replies - this gives me enough to work with.