Home » Developer & Programmer » JDeveloper, Java & XML » inserting data finto table from a clob column (oracle 10g, windows 2000 server)
inserting data finto table from a clob column [message #343371] Wed, 27 August 2008 01:36 Go to next message
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.
Re: inserting data finto table from a clob column [message #343377 is a reply to message #343371] Wed, 27 August 2008 02:01 Go to previous message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Convert the CLOB into an XMLTYPE and then use the extract function on that.
Previous Topic: Export into xml
Next Topic: java.security.AccessControlException - the Permission has not been granted
Goto Forum:
  


Current Time: Wed Aug 20 14:15:31 CDT 2014

Total time taken to generate the page: 0.06927 seconds