xpath/xquery sql - Get all values

Hi I have a blob of xml..

<string>1</string>
<string>2</string>
<string>3</string>
<string>4</string>
<string&g开发者_如何学JAVAt;11</string>
<string>1211</string>
<string>12331</string>

how would I get all the values using xpath/xquery in SQL

Thanks

The xpath //string will return all the values in the intire xml the xpath /string will return only the values in the root node.

And for using it in sql look at this post XPath to fetch SQL XML value

in oracle database

you have XMLType (see this) data type..

by this datatype you can get all the value..

all the examples are there itself, please go through that site.