Thursday, December 3, 2009
XMLSERIALIZE (XML to CLOB)
SELECT XMLSERIALIZE( X.XML_FIELD AS CLOB(80) EXCLUDING XMLDECLARATION)
FROM YY.TABLE X
FROM YY.TABLE X
# posted by Domen Dolar @ 10:11 AM 
Domen Dolar
Links
- IZLOCI.info
- eZdravstvo.si
- Hints for Oracle
- Information Management Software for z/OS Solutions Information Center
- EGL Cafe
Source
Previous Posts
- Read DB2 ZOs repository objects
- DUAL ORACLE = SYSIBM.SYSDUMMY1 IBM
- SEQUENCE NEXT value for DB2
- DB2 ZOs RACF group privileges
- XMLPARSE and XMLTABLE sample for dynamic SQL (CLOB...