Query a XML string for a specific field value in oracle SQL

1	select extractvalue(XMLTYPE(inputxml), '/ROOT/DATA/ELEMENT') "Value" from MYTABLE

Where inputxml is a varchar2 column (storing xml as a string)
if you are storing data in a Xml datatype, you can remove XMLTYPE() function call