oracle xml类型字段的索引

create index IndexName on TableName(FieldName) indextype is ctxsys.ctxxpath;
create index IndexName on TableName(extractValue(FieldName,'/DocumentInfo/Sharers'));

 

程序员的基础教程：菜鸟程序员