select
algorithm_id, -- ALGORITHM_ID NUMBER
algorithm_name, -- ALGORITHM_NAME VARCHAR2(64)
algorithm_description, -- ALGORITHM_DESCRIPTION VARCHAR2(64)
is_default, -- IS_DEFAULT VARCHAR2(3)
restore_only -- RESTORE_ONLY VARCHAR2(3)
from
gv$rman_encryption_algorithms
where
inst_id = USERENV('Instance')