Oracle xml数据构建 XMLType相关函数

准备测试数据：create table teacher (id varchar2(10),name varchar2(20),remark varchar2(50));create table course (id varch

xmltransform（xmltype_instance,xsl_ss)：该函数用于将xmltype实例按照xsl样式进行转换，并生成新的xmltype实例。示例如下：
sql> select xmltransform(w.warehouse-spec,x.coll).getclobval()
2 from warehouse w,xsl_tab x
3 where w.warehouse_name='san francisco';

create table purchase_order( po_no number(9),po_file xmltype)

insert into purchase_order values(68,xmltype('<?xml version="1.0" encoding="utf-8"?>
 

index.jsp
1


index2.jsp
2

'))


select extract(po_file,'out/record/filename').getstringval() as filename,extract(po_file,'out/record/fileid').getstringval() as fileid from purchase_order

select extract(po_file,'out/record/@id').getstringval() as record from purchase_order


select extract(po_file,'out/record/filename').getstringval() as filename from purchase_order


select extractvalue(value(i),'/filename') as filename 
from purchase_order x,
table(xmlsequence(extract(x.po_file,'out/record/filename'))) i

，