select
pol.object_owner,
pol.object_name,
pol.policy_group,
pol.policy_name,
pol.pf_owner,
pol.package,
pol.function,
case when pol.sel = 'YES' then 'sel' end "sel",
case when pol.ins = 'YES' then 'ins' end "ins",
case when pol.upd = 'YES' then 'upd' end "upd",
case when pol.del = 'YES' then 'del' end "del",
case when pol.idx = 'YES' then 'idx' end "idx",
pol.chk_option,
pol.enable,
pol.static_policy,
pol.policy_type,
pol.long_predicate,
pol.common,
pol.inherited
from
dba_policies pol
where
-- pol.policy_name = '…'
pol.object_name like 'TQ84_T1%';