VIEW: SYS.DBA_ADVISOR_DIR_DEFINITIONS

Source

View Text - Preformatted

select a.id as id,
             a.advisor_id as advisor_id,
             b.name as advisor_name,
             a.name as directive_name,
             a.domain as domain_name,
             a.description as description,
             a.type# as type,
             decode(a.type#,1,'Filter',2,'Single value',3,'Multiple Values',
                            4,'Conditional',5,'Constraint','Unknown') as type_name,
             decode(bitand(a.flags,1),1,'MUTABLE','IMMUTABLE') as task_status,
             decode(bitand(a.flags,2),2,'MULTIPLE','SINGLE') as instances,
             c.data as metadata
      from wri$_adv_directive_defs a, wri$_adv_definitions b,
           wri$_adv_directive_meta c
      where a.advisor_id = b.id
        and a.metadata_id = c.id

View Text - HTML Formatted

SELECT A.ID AS ID
, A.ADVISOR_ID AS ADVISOR_ID
, B.NAME AS ADVISOR_NAME
, A.NAME AS DIRECTIVE_NAME
, A.DOMAIN AS DOMAIN_NAME
, A.DESCRIPTION AS DESCRIPTION
, A.TYPE# AS TYPE
, DECODE(A.TYPE#
, 1
, 'FILTER'
, 2
, 'SINGLE VALUE'
, 3
, 'MULTIPLE VALUES'
, 4
, 'CONDITIONAL'
, 5
, 'CONSTRAINT'
, 'UNKNOWN') AS TYPE_NAME
, DECODE(BITAND(A.FLAGS
, 1)
, 1
, 'MUTABLE'
, 'IMMUTABLE') AS TASK_STATUS
, DECODE(BITAND(A.FLAGS
, 2)
, 2
, 'MULTIPLE'
, 'SINGLE') AS INSTANCES
, C.DATA AS METADATA
FROM WRI$_ADV_DIRECTIVE_DEFS A
, WRI$_ADV_DEFINITIONS B
, WRI$_ADV_DIRECTIVE_META C
WHERE A.ADVISOR_ID = B.ID
AND A.METADATA_ID = C.ID