Welcome aboard! We are happy you are here and wish you good net-raft!
// Oracle9i
select SYS_XMLGEN(contact_name) from customers;
// in release1
select SYS_XMLGEN(contact_name).getStringVal() from customers;
// this one create one xml document
select SYS_XMLAGG(SYS_XMLGEN(contact_name)) from customers;
// in release1
select SYS_XMLAGG(SYS_XMLGEN(contact_name))).getStringVal() from customers;
The most helpful ORACLE SQL solutions
add grant oracle sqlORACLE SQL Click to see more ... 289 33