1 Reply Latest reply: Nov 30, 2012 1:27 AM by odie_63 RSS

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

      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'