select xmltype(dataxml).extract(‘/data/sqr_mc/text()‘).getstringval() as sqrmc
from t_ins_formdata where bsnum=‘170215085821005401‘
select xmltype(dataxml).extract(‘/data/sqr_mc/text()‘).getstringval() as sqrmc
from t_ins_formdata where bsnum=‘170215085821005401‘
原文：https://www.cnblogs.com/auldlangsynezh/p/8178196.html