VIEW: SYS.USER_ADVISOR_OBJECTS

Source

View Text - Preformatted

select a.id as object_id,
            c.object_type as type,
            a.type as type_id,
            a.task_id as task_id,
            b.name as task_name,
            a.exec_name as execution_name,
            a.attr1 as attr1,
            a.attr2 as attr2,
            a.attr3 as attr3,
            (case
               when b.advisor_id = 1 and
                    a.type = 7 and
                    length(attr4) = 1 and       /* attr4 has ' ' as default val */
                    a.attr1 is not null
               then (select nvl(sql_text, ' ')  /* backwards compat w/ tests */
                     from wrh$_sqltext s, wri$_adv_addm_tasks t
                         where t.task_id = a.task_id
                           and s.dbid(+) = t.dbid
                           and s.sql_id(+) = a.attr1)
               else a.attr4
             end) as attr4,
            a.attr5 as attr5,
            a.attr6 as attr6,
            a.attr7 as attr7,
            a.attr8 as attr8,
            a.attr9 as attr9,
            a.attr10 as attr10,
            a.attr11 as attr11,
            a.attr16 as attr16,
            a.attr17 as attr17,
            a.attr18 as attr18,
            a.other as other
      from wri$_adv_objects a, wri$_adv_tasks b, x$keaobjt c
      where a.task_id = b.id
        and b.owner# = userenv('SCHEMAID')
        and c.indx = a.type

View Text - HTML Formatted

SELECT A.ID AS OBJECT_ID
, C.OBJECT_TYPE AS TYPE
, A.TYPE AS TYPE_ID
, A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.EXEC_NAME AS EXECUTION_NAME
, A.ATTR1 AS ATTR1
, A.ATTR2 AS ATTR2
, A.ATTR3 AS ATTR3
, (CASE WHEN B.ADVISOR_ID = 1 AND A.TYPE = 7 AND LENGTH(ATTR4) = 1
AND /* ATTR4 HAS ' ' AS DEFAULT VAL */ A.ATTR1 IS NOT NULL THEN (SELECT NVL(SQL_TEXT
, ' ') /* BACKWARDS COMPAT W/ TESTS */
FROM WRH$_SQLTEXT S
, WRI$_ADV_ADDM_TASKS T
WHERE T.TASK_ID = A.TASK_ID
AND S.DBID(+) = T.DBID
AND S.SQL_ID(+) = A.ATTR1) ELSE A.ATTR4 END) AS ATTR4
, A.ATTR5 AS ATTR5
, A.ATTR6 AS ATTR6
, A.ATTR7 AS ATTR7
, A.ATTR8 AS ATTR8
, A.ATTR9 AS ATTR9
, A.ATTR10 AS ATTR10
, A.ATTR11 AS ATTR11
, A.ATTR16 AS ATTR16
, A.ATTR17 AS ATTR17
, A.ATTR18 AS ATTR18
, A.OTHER AS OTHER
FROM WRI$_ADV_OBJECTS A
, WRI$_ADV_TASKS B
, X$KEAOBJT C
WHERE A.TASK_ID = B.ID
AND B.OWNER# = USERENV('SCHEMAID')
AND C.INDX = A.TYPE