SQL query for encrypted tablespaces and tables

Hi All -

We are trying to fulfill an auditing requirement where we are being asked to list out the encryption details of a particular application at the database level. Specifically, we need to provide the tablespace, table, and encryption method (algorithm).

We had tried this, but we aren't getting the encryption algorithm as part of the results. We'd appreciate any help to get the results, as required by the audit team

select table_name, tablespace_name from dba_tables where tablespace_name
in (select b.name from v$encrypted_tablespaces a, v$tablespace b
where a.TS# = b.TS#)
order by 2 desc;