select a.trust, b.dbname from sys.trusted_list$ b,
(select decode (dbname, '+*','Untrusted', '-*', 'Trusted') trust
from sys.trusted_list$ where dbname like '%*') a
where b.dbname not like '%*'
union
select decode (dbname, '-*', 'Untrusted', '+*', 'Trusted') trust, 'All'
from sys.trusted_list$
where dbname like '%*'
SELECT A.TRUST
, B.DBNAME
FROM SYS.TRUSTED_LIST$ B
,
(SELECT DECODE (DBNAME
, '+*'
, 'UNTRUSTED'
, '-*'
, 'TRUSTED') TRUST
FROM SYS.TRUSTED_LIST$
WHERE DBNAME LIKE '%*') A
WHERE B.DBNAME NOT LIKE '%*'
UNION
SELECT DECODE (DBNAME
, '-*'
, 'UNTRUSTED'
, '+*'
, 'TRUSTED') TRUST
, 'ALL'
FROM SYS.TRUSTED_LIST$
WHERE DBNAME LIKE '%*'
|
|
|