DBA Data[Home] [Help]

VIEW: SYS.USER_ENCRYPTED_COLUMNS

Source

View Text - Preformatted

select TABLE_NAME, COLUMN_NAME, ENCRYPTION_ALG,SALT, INTEGRITY_ALG from DBA_ENCRYPTED_COLUMNS
  where OWNER = SYS_CONTEXT('USERENV','CURRENT_USER')
View Text - HTML Formatted

SELECT TABLE_NAME
, COLUMN_NAME
, ENCRYPTION_ALG
, SALT
, INTEGRITY_ALG
FROM DBA_ENCRYPTED_COLUMNS
WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')