Home » Developer & Programmer » JDeveloper, Java & XML » storing xml file in oracle9i
storing xml file in oracle9i [message #91434] Tue, 03 September 2002 07:36 Go to next message
Messages: 1
Registered: September 2002
Junior Member
Hi Friends,
I want to put XML file into oracle 9i and edit it as and when required.
How do I do this?
Your help would be greatly appreciated.
Thanking you
Re: storing xml file in oracle9i [message #91436 is a reply to message #91434] Wed, 04 September 2002 06:24 Go to previous message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
do you want to store XML file in oracle?
then use CLOBS. thats easy(if you want to store and retrieve XML from the DB).
with 9i there is a new datatype XMLType, which stores XML documents as CLOBs and enables xpath type queries 
if you want to load XML data then use XML SQL Utility (XSU).
Oracle docs can provide more information.

Previous Topic: Re: sample test questions for OCP exams IZO-501/502/504/505
Next Topic: java storedproc HELP
Goto Forum:

Current Time: Wed Nov 30 04:47:04 CST 2022