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')