• 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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