Oracle需要XML解析的帮助

create table t (
c1 varchar2(1000)
);
insert into t values ( '

4811111111

NBI



0
Success

'
);
commit;
select cast (
extract (
xmltype ( t.c1 ),
'//newSubscriberNumber/text()',
'xmlns="http://csi.abc.com/CSI/Namespaces/Container/Public/ChangeSubscriberNumberResponse.xsd" xmlns:ns2="http://csi.abc.com/CSI/Namespaces/Types/Public/abc.xsd"'
)
as varchar2(100)
) as fault_string
from t;
FAULT_STRING
4811111111