29 lines
615 B
MySQL
29 lines
615 B
MySQL
select
|
|
hint as outline_hints
|
|
from
|
|
( select
|
|
p.name,
|
|
p.signature,
|
|
p.category,
|
|
row_number() over
|
|
( partition by
|
|
sd.signature,
|
|
sd.category
|
|
order by
|
|
sd.signature
|
|
) row_num,
|
|
extractValue(value(t), '/hint') hint
|
|
from
|
|
sys.sqlobj$data sd,
|
|
dba_sql_profiles p,
|
|
table(xmlsequence(extract(xmltype(sd.comp_data), '/outline_data/hint'))) t
|
|
where
|
|
sd.obj_type = 1
|
|
and p.signature = sd.signature
|
|
and p.category = sd.category
|
|
and p.name like ('%&profile_name%)
|
|
)
|
|
order by
|
|
row_num
|
|
;
|