OraFAQ Forum: JDeveloper, Java & XML » inserting data finto table from a clob column

Home » Developer & Programmer » JDeveloper, Java & XML » inserting data finto table from a clob column (oracle 10g, windows 2000 server)

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

inserting data finto table from a clob column [message #343371]

Wed, 27 August 2008 01:36

tarikkuet@yahoo.com
Messages: 3
Registered: August 2008

Junior Member

I have a table that has a column(clob type) which contains a xml file. The file contains the data of a table in xml format. what i need is insert the file data into desired table i.e the xml file data to a table. Pls help me.

Report message to a moderator

Re: inserting data finto table from a clob column [message #343377 is a reply to message #343371]

Wed, 27 August 2008 02:01

ThomasG
Messages: 2881
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Convert the CLOB into an XMLTYPE and then use the extract function on that.

Report message to a moderator

Previous Topic:	Export into xml
Next Topic:	java.security.AccessControlException - the Permission has not been granted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 14:52:24 CDT 2013

Total time taken to generate the page: 0.51634 seconds