Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

xml data

How do I extract xml data into text in Oracle? Please provide with detail steps, thanks.
0
lium1
Asked:
lium1
  • 3
  • 2
2 Solutions
 
sdstuberCommented:
if you can give an example I can give a more precise answer but, in general  you'll use these functions...

EXTRACT
EXTRACTVALUE
XMLTABLE


as an example,  check out this question   http://www.experts-exchange.com/Q_27325493.html#36601619
0
 
slightwv (䄆 Netminder) Commented:
The steps depend on the xml and the requirements.

Please provide sample data and expected results.

Until then check out the EXTRACTVALUE sql function.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
lium1Author Commented:
The solution has not direct impact on the issue.
0
 
slightwv (䄆 Netminder) Commented:
Instead of the 'B' grade, if you needed additional information why didn't you ask?
0
 
sdstuberCommented:
I disagree with the closing statement as well.

Given those are the exact functions needed,  how could they NOT have a direct impact?

If you needed more specifics,  then as noted in the very first post, you need to provide additional details for us to work with.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now