16 lines
257 B
MySQL
16 lines
257 B
MySQL
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 like nvl('&sql_id',sql_id)
|
|
and child_number = &child_no
|
|
and other_xml is not null
|
|
)
|
|
) d;
|