xml inside a database
Posted by:
asd 123
Date: April 20, 2012 08:34AM
Hello,
I have a huge some xml files of same format. Each of them are stores in a blob cloumn inside a table.
Is there any way that I can query on all xml files together such that the result would be the xml files which fufllfils my query
for e.g.
Table
Primary key ----------file_name -----------------filedata(blob)
1 ---------------------output1 ---------------------blob(file)
2 ---------------------output2 ---------------------blob(file)
3 ---------------------output3 ---------------------blob(file)
If I want to search for the xml files which consist of string "John" inside a node called employee.
A bit more complex query would be to return the salary of the employee by name "John".
Then I should get the first two rows as a result.
thanks,
Srikanth
Edited 2 time(s). Last edit at 04/20/2012 08:43AM by asd 123.
Subject
Written By
Posted
xml inside a database
April 20, 2012 08:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.