Question

oracle A字段为xmltype类型的内容查询,求大佬帮忙。

<PatientCase><Pages><Page num="1"><Texts><Text FaliasName="" fbh="Text_2"><Tybh>10625</Tybh><fjb>0</fjb><Value>富豪</Value><Styles><Style><StyleData/><Writer>10625</Writer><WriteDate>2016-05-01 13:14</WriteDate><Start>0</Start><Length>1</Length><Sub>0</Sub><Pub>0</Pub><FontName>楷体_GB2312</FontName><FontHeight>12</FontHeight><FontStyle>0</FontStyle><Rise>0</Rise><UnderLine>0</UnderLine><DoubleUnderLine>0</DoubleUnderLine><DeleteLine>0</DeleteLine></Style></Styles><linespace>0.0</linespace><SignImages/><DrawImages/></Text><Text FaliasName="" fbh="Text_3"><Tybh>10625</Tybh><fjb>0</fjb><Value>迪拜</Value><Styles><Style><StyleData/><Writer>10625</Writer><WriteDate>2016-05-01 13:14</WriteDate><Start>0</Start><Length>4</Length><Sub>0</Sub><Pub>0</Pub><FontName>楷体_GB2312</FontName><FontHeight>12</FontHeight><FontStyle>0</FontStyle><Rise>0</Rise><UnderLine>0</UnderLine><DoubleUnderLine>0</DoubleUnderLine><DeleteLine>0</DeleteLine></Style></Styles><linespace>0.0</linespace><SignImages/><DrawImages/></Text><Text FaliasName="" fbh="Text_4"><Tybh>10625</Tybh><fjb>0</fjb><Value>张三</Value><Styles><Style><StyleData/><Writer>10625</Writer><WriteDate>2016-05-01 13:14</WriteDate><Start>0</Start><Length>4</Length><Sub>0</Sub><Pub>0</Pub><FontName>楷体_GB2312</FontName><FontHeight>12</FontHeight><FontStyle>0</FontStyle><Rise>0</Rise><UnderLine>0</UnderLine><DoubleUnderLine>0</DoubleUnderLine><DeleteLine>0</DeleteLine></Style></Styles><linespace>0.0</linespace><SignImages/><DrawImages/></Text><Text FaliasName="" fbh="Text_5"><Tybh>10625</Tybh><fjb>0</fjb><Value>男</Value><Styles><Style><StyleData/><Writer>10625</Writer><WriteDate>2016-05-01 13:14</WriteDate><Start>0</Start><Length>1</Length><Sub>0</Sub><Pub>0</Pub><FontName>楷体_GB2312</FontName><FontHeight>12</FontHeight><FontStyle>0</FontStyle><Rise>0</Rise><UnderLine>0</UnderLine><DoubleUnderLine>0</DoubleUnderLine><DeleteLine>0</DeleteLine></Style></Styles><linespace>0.0</linespace><SignImages/><DrawImages/></Text><Text FaliasName="" fbh="Text_6"><Tybh>10625</Tybh><fjb>0</fjb><Value>汉族</Value><Styles><Style><StyleData/><PatientCase/>

Answer 1

to_char转换一下就行了

1

select 其他字段,to_char(clob字段) from 表名