Home » Developer & Programmer » JDeveloper, Java & XML » How to parse xml using plsql (oracle 10g)
How to parse xml using plsql [message #382489] Thu, 22 January 2009 11:21 Go to next message
Mariane
Messages: 1
Registered: January 2009
Junior Member
Hello everyone,

I am new to xml and Oracle and have the following question.

I have a xml file like:
<HL>
<ID>
<NUMBER>1234</NUMBER>
<YEAR>2007</YEAR>
.... etc
</ID>
<PERSON>
<NAME>JOHN</NAME>
....etc
</PERSON>
<ADDRESS>
<STREET></STREET>
</ADDRESS>
... etc
</HL>
Now I need to select the value of element <NUMBER>.
How can I do that using PL/SQL?
I have been reading a lot about the XMLDOM in Oracle but I find it hard to grasp without an example that means something to me.
Can someone help me?

Thanks in advance.
regards

Report message to a moderator

Re: How to parse xml using plsql [message #382497 is a reply to message #382489] Thu, 22 January 2009 11:46 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just read a couple of messages in this forum and you will know how to do it.

Also read OraFAQ Forum Guide, especially sections explaining how to post.

Regards
Michel

Report message to a moderator

Previous Topic: How to write a Java code in oracle
Next Topic: couldn't connect to database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 22:50:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.