Skip to content
Home » Oracle » What Table Columns are Encrypted?

What Table Columns are Encrypted?

Column Level Encryption

In this use case, we have built encryption infrastructure on the database and developers have encrypted some columns. Now we would like know which columns are encrypted.

Here is the query statement that can check which columns are encrypted.

SQL> column owner format a10;
SQL> column table_name format a20;
SQL> column column_name format a20;
SQL> select owner, table_name, column_name from all_encrypted_columns order by 1,2,3;

---------- -------------------- --------------------
ERPAPP     PAY_DAILY            DAILK351
ERPAPP     PAY_DAILY            DAILK456
ERPAPP     PAY_DAILY            DAILK661
ERPAPP     PAY_HISTO            HISTK344
ERPAPP     PAY_HISTO            HISTK411
ERPAPP     PAY_WEEKLY           WEEKK814
ERPAPP     PAY_WEEKLY           WEEKK436
ERPAPP     PAY_WEEKLY           WEEKK741

8 rows selected.

As we can see, there're 8 columns that have been encrypted in the database.

By the way, there's no actual table level encryption. However, you can alternatively move the table to the encrypted tablespace to make the whole table encrypted. But you have to know which tablespaces are encrypted.

Leave a Reply

Your email address will not be published. Required fields are marked *