How to find the clear text data in an encrypted column?

Ozone

Hi,

I need to know how to validate encrypted column which may by chance loads clear text or unencrypted value. An exception should be triggered if encrypted column receives any clear text data. kinldy help me out in solving this!!

debasisdas

Compare the original data after decrypting the encrypted data.
If both matches, it is encrypted.

if it is not encrypted and you decrypt and compare it will not match.

How to find the clear text data in an encrypted column?

re: How to find the clear text data in an encrypted column?

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about