Thursday, November 30, 2006
Create XML from SQL
Sample.
select
xmlelement(
"CUS", xmlelement(
"ROWS", xmlagg(xmlelement(
"ROW", xmlelement(
"URL", url),xmlelement(
"TIME", time),xmlelement(
"STATUS", status),xmlelement(
"TEXT",text)
)
))
).getclobval()
from check_url_status
# posted by Domen Dolar @ 10:33 PM 
