|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
June 30th, 2004, 11:11 AM
|
|||
|
|||
Converting XMLTYPE to other datatypes
I was wondering how I could go about converting entries in an XML object into other datatypes such as varchar2. I read on the oracle site that table functions can do this, but I have no been able to find any websites with further information on the subject. If anyone can give me some insight as to how to convert XMLTYPE to other datatypes, it will be greatly appreciated.
|
|
#2
July 4th, 2004, 03:06 AM
|
|||
|
|||
|
Once you have an XMLTYPE object, just call "GetStringVal()", "GetClobVal()" or "GetNumberVal()" on that object. Could be as simple as:
select xmltype.createxml('<foo>text</foo>').GetStringVal() from dual;
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Converting XMLTYPE to other datatypes |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
