I have a requirement to encrypt NUMBER datatype in Oracle 19c. The requirement is to encrypt the data, and update the same to the column. After a while, if needed, the data has to be decrypted and provided to the customers.
I found the DBMS_CRYPTO package, which provides the encryption. I found examples for VARCHAR2 datatype, but none for numeric.
On trying to encrypt the NUMBER column, the encryption results in an alphanumeric, which cannot be updated in the column.
How can my objective of encrypting the numeric column and updating the same be achieved? Is DBMS_CRYPTO the right way to proceed for this?