SELECT value(xmlt).getstringval() Attribute_Value FROM table(XMLSequence(extract(XMLType(' <Year> <Y>2010</Y> <Y>2011</Y> <LY>2012</LY> <Year>'), '/Year/Y'))) xmlt;
SELECT value(xmlt).getstringval() Attribute_Value FROM table(XMLSequence(extract(XMLType(' <Year> <Y>2010</Y> <Y>2011</Y> <LY>2012</LY> <Year>'), '/Year/LY'))) xmlt;
70017