DBA Data[Home] [Help]

VIEW: SYS.USER_SQLTUNE_BINDS

Source

View Text - Preformatted

SELECT b.task_id, b.object_id, b.position, b.value
  FROM   wri$_adv_sqlt_binds b, wri$_adv_objects o, wri$_adv_tasks t
  WHERE  b.object_id = o.id and b.task_id = o.task_id and o.task_id = t.id and
         t.owner# = SYS_CONTEXT('USERENV', 'CURRENT_USERID')
View Text - HTML Formatted

SELECT B.TASK_ID
, B.OBJECT_ID
, B.POSITION
, B.VALUE
FROM WRI$_ADV_SQLT_BINDS B
, WRI$_ADV_OBJECTS O
, WRI$_ADV_TASKS T
WHERE B.OBJECT_ID = O.ID
AND B.TASK_ID = O.TASK_ID
AND O.TASK_ID = T.ID AND T.OWNER# = SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')