OraFAQ Forum: JDeveloper, Java & XML » storing xml file in oracle9i

Home » Developer & Programmer » JDeveloper, Java & XML » storing xml file in oracle9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

storing xml file in oracle9i [message #91434]

Tue, 03 September 2002 07:36

vanita
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
Vanita
IIITMK

Report message to a moderator

Re: storing xml file in oracle9i [message #91436 is a reply to message #91434]

Wed, 04 September 2002 06:24

Mahesh Rajendran
Messages: 10707
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 
else
if you want to load XML data then use XML SQL Utility (XSU).
Oracle docs can provide more information.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 18:02:02 CDT 2024