SQL STORED PROCEDURE

padmapriya patruni

11y921

this is xml file in my table . i need to display this file as a XML Format using stored procedure. please help me

Gambardella, MatthewXML Developer's GuideComputer44.952000-10-01An in-depth look at creating applications

with XML.Ralls, KimMidnight RainFantasy5.952000-12-16A former architect battles corporate zombies,

an evil sorceress, and her own childhood to become queen

of the world.Corets, EvaMaeve AscendantFantasy5.952000-11-17After the collapse of a nanotechnology

society in England, the young survivors lay the

foundation for a new society.Corets, EvaOberon's LegacyFantasy5.952001-03-10In post-apocalypse England, the mysterious

agent known only as Oberon helps to create a new life

for the inhabitants of London. Sequel to Maeve

Ascendant.Corets, EvaThe Sundered GrailFantasy5.952001-09-10The two daughters of Maeve, half-sisters,

battle one another for control of England. Sequel to

Oberon's Legacy.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
If you have entire XML content in your DB then what is problem to display data. Is that column is XML data type. If yes then simple SQL query should work fine.

Select * from tablename;
0
padmapriya patruni11y ago
hello manas.

actually my db having entir xml file . but i need to display like this

Gambardella, Matthew
XML Developer's Guide
Computer
44.95
2000-10-01
An in-depth look at creating applications with XML.

0
Manas Mohapatra11y ago
Did you tried anything to achieve the funcaionality. If you are getting error provide here.

Secondly if xml data is present in DB then you can simply fetch it as normal way. Let me know if I am wrong to understand your problem.
0