问Oracle中的Sql配置文件

EN

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 ('<add profile_name from above>')
)
order by row_num;