Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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