DBA Data[Home] [Help]

VIEW: SYS.DBA_SENSITIVE_COLUMN_TYPES

Source

View Text - Preformatted

select
 t.name,
 t.user_comment,
 s.name,
 decode(s.type, 1, 'DB', 2, 'ADM')
from sys.tsdp_sensitive_type$ t, sys.tsdp_source$ s where t.source#=s.source#
View Text - HTML Formatted

SELECT T.NAME
, T.USER_COMMENT
, S.NAME
, DECODE(S.TYPE
, 1
, 'DB'
, 2
, 'ADM') FROM SYS.TSDP_SENSITIVE_TYPE$ T
, SYS.TSDP_SOURCE$ S
WHERE T.SOURCE#=S.SOURCE#