Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by sqleer
-
help with extracting value of xml tags
Once again tsuji, Thank you. select extractvalue(xmltype(data),'/java/object/void[@property="dbHome"]/string') db_home from config DB_HOME -------------------------------------------------------------------------------- C:\Portware SQL> -
help with extracting value of xml tags
another question, given: <?xml version="1.0" encoding="UTF-8"?> <java version="1.4.2_11" class="java.beans.XMLDecoder"> <object class="com.indigo.utils.properties.EnvironmentProperties" <void property="basketserverMemory"> <string>384m</string> </void> <void property="clientMemory">... -
help with extracting value of xml tags
Thank you so much for your help. This works SQL> SELECT EXTRACTVALUE(data,'//@value[../@key="Root"]')attr 2 from tm_data 3 / C:/Portware -
help with extracting value of xml tags
..using your xpath, and following the extracvalue syntax using xpath from this link: http://www.adp-gmbh.ch/ora/sql/extractvalue.html ..i am still having issues..forgive my novice status.. SQL> SELECT EXTRACTVALUE(data,'"//@value[../@key='Root']"')attr 2 from tm_data 3 / SELECT... -
help with extracting value of xml tags
Thank you for your response. I am trying to follow this example using xmlnamespace SQL> with t as ( 2 select xmltype('<?xml version="1.0" encoding="ISO-8859-1"?> 3 <?xml-stylesheet type="text/xsl" href="../oper_fct.xsl"?> 4 <test abc:thisone="O1" xmlns="abc" xmlns:abc="abc" 5... -
help with extracting value of xml tags
Howdy, I am an Oracle DBA and new to XML parsing. Given the following data sample, I would like to achieve two things. 1. extract only the value of the "Root" tag which is C:\Flintstone 2. extract the tag "TM_PORT" and its value The column is a CLOB. thank you <?xml version="1.0"...
