DBA Data[Home] [Help]

VIEW: SYS.DBA_OUTLINE_HINTS

Source

View Text - Preformatted

select o.ol_name, o.creator, h.node#, h.stage#, h.table_pos,
       NVL(h.hint_string, h.hint_text)
from outln.ol$ o, outln.ol$hints h
where o.ol_name = h.ol_name
View Text - HTML Formatted

SELECT O.OL_NAME
, O.CREATOR
, H.NODE#
, H.STAGE#
, H.TABLE_POS
, NVL(H.HINT_STRING
, H.HINT_TEXT) FROM OUTLN.OL$ O
, OUTLN.OL$HINTS H WHERE O.OL_NAME = H.OL_NAME