VIEW: SYS.DBA_ADVISOR_SQLW_TEMPLATES

Source

View Text - Preformatted

select b.owner_name as owner,
             b.id as workload_id,
             b.name as workload_name,
             b.description as description,
             b.ctime as create_date,
             b.mtime as modify_date,
             b.source as source,
             decode(bitand(b.property,1),1,'TRUE','FALSE') as read_only
      from wri$_adv_sqlw_sum a, wri$_adv_tasks b
      where a.workload_id = b.id
        and bitand(b.property,2) = 2
        and b.advisor_id = 6

View Text - HTML Formatted

SELECT B.OWNER_NAME AS OWNER
, B.ID AS WORKLOAD_ID
, B.NAME AS WORKLOAD_NAME
, B.DESCRIPTION AS DESCRIPTION
, B.CTIME AS CREATE_DATE
, B.MTIME AS MODIFY_DATE
, B.SOURCE AS SOURCE
, DECODE(BITAND(B.PROPERTY
, 1)
, 1
, 'TRUE'
, 'FALSE') AS READ_ONLY
FROM WRI$_ADV_SQLW_SUM A
, WRI$_ADV_TASKS B
WHERE A.WORKLOAD_ID = B.ID
AND BITAND(B.PROPERTY
, 2) = 2
AND B.ADVISOR_ID = 6