SQLTeam.com | Weblogs | Forums

How to use extract value and xmltype in SQL

sql2012

#1

select extractvalue(xmltype(message_text), 'message/detail/recordID'), ,)extractvalue(xmltype(messagetext,'/message/detail/header/message), SYS_NBR, message_type
FROM prod.tb_ibrs
Where message_type = 'ERR'
order by cre_on desc;