Encryption Decryption in Oracle
Posted on 2016-10-28
I've an application built on VB.NET and it's using Oracle DB. The application was in use since couple of year and database have records in it.
I like to encrypt few sensitive data in database and decrypt it while accessing in application. here's few questions that i've. could someone answer?
I don't want to purchase any additional oracle license for encryption, rather like to use any existing feature to achieve this.
1. Is there a way to use oracle package or query to encrypt, decrypt the data without changing the application code?
2. If it's not possible in Oracle query, what is the best way to encrypt and decrypt the data with minimal code change?
3. How do i encrypt the Date column in database? I think other data type can be encrypted using either oracle query or .net code but I've doubt on Date column.
Any input/suggestion will be greatly appreciated.