question

sandman147 avatar image
sandman147 asked

Extract the value of a field from an xml column through SqlDeveloper

**Extract the value from an xml column from oracle database through SqlDeveloper** I have with me; Database: CT Table: ART Column with xmltype data: AUDI ----------------------------------------------------------------------------------------- 83473493 8748374343 395096 oihfiohe 444kj34 email 4 tiger@gmail.com 8490yhh3049 **MY QUESTION**: How do I extract/retrieve only the value under 'address' i.e; tiger@gmail.com in SqlDeveloper ?
sqlxmlselect
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sqlaj 1 avatar image
sqlaj 1 answered
XML can be a confusing mess at times. Take a look at this post and look for the section named, "**Using XMLType in an SQL Statement**". > **Oracle9i XML Database Developer's Guide - Oracle XML DB** > http://docs.oracle.com/cd/B10500_01/appdev.920/a96620/xdb04cre.htm It shows an example of how to query xml by walking the tree.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.