This discussion is archived
1 Reply Latest reply: Nov 29, 2012 11:27 PM by odie_63 RSS

extracting parameter in XML data when left tag is associated with Variable

977129 Newbie
Currently Being Moderated
Help needed into extract value for release field. Left Tag is associated with release_Id value for different release fields values of MD and AL.

case a) <release_id="50620">MD</release>
case b) <release_id="50621">AL</release>
case c) If release field is null, tags wont be created.

The following sql function did not work. could you please suggest me. if you need any further info, please let me know.

select extractvalue(CONVERT_BLOB_TO_XMLTYPE(xml), '/cutom-data/release')
from ASSETXML
where id='50268'

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points