set verify off

define SQL_ID=&1
define CHILD_NO=&2

select extractvalue(value(d), '/hint') as outline_hints
from xmltable('/*/outline_data/hint'
  passing (
    select xmltype(other_xml) as xmlval
    from v$sql_plan
    where sql_id='&SQL_ID'
      and child_number = &CHILD_NO
      and other_xml IS NOT NULL
  )
) d
/

undef SQL_ID
undef CHILD_NO