What's new in Customer Journeys?

Connect and learn more!
Transparent Data Encryption — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Transparent Data Encryption

Received Response
61
Views
4
Comments

We are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database.

we have used the below query for creating a table with encrpted column, but when we try to retrive the data using sql or ORDS its behaving as ordinary column & giving the data as it is.

CREATE TABLE employee (

   first_name VARCHAR2(128),

   last_name VARCHAR2(128),

   empID NUMBER,

   salary NUMBER(6) ENCRYPT)

 

kindly let us know if am doing anything wrong.We are refering to the below blogs for TDE.

https://docs.oracle.com/en/database/oracle/oracle-database/21/asoag/encrypting-columns-tables2.html#GUID-A0E2C279-10F6-48D9-AB92-C547529C06EE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!