I have a field in Oracle table with XML data that varies in size and position. I need to pull out the data from some of these nodes using SQL.
For example in the XML below the node &BADGE_NUM contains the value TEST05. I would like to write an sql that returns TEST05 in a specific column. I cannot use SUBSTR because fields prior to BADGE_NUM vary in length so BADGE_NUM is not always in the same position.