Resurrecting an old thread...
On Thursday, Aug 15, 2002, at 21:41 US/Pacific, Matt Liotta wrote:
> http://www.devx.com/xml/articles/ml062502/ml062502-1.asp. The article
Interesting article. I've just started looking at Oracle's native XML
support in 9i (release 9.2). It looks very promising... a way to get
the best of both worlds. You can return XML from a standard SQL query
on a relational table, you can mix relational and XML data in a record,
you can aggregate records into a single XML document etc. You can see
some syntax examples here:
http://otn.oracle.com/tech/xml/xmldb/htdocs/sql_xml_codeexamples.html
e.g.,
select xmlelement("emp",
xmlattributes(e.job || ' ' || e.ename as "name"),
xmlelement("department", e.deptno),
xmlelement("depts", (SELECT COUNT(*)
FROM scott.dept d
where d.deptno = e.deptno))) as result
from scott.emp e;
You will need to register with Oracle TechNet to view this - worth
doing, it's free and there's a lot of useful information there
(including online docs with full SQL specs).
I'll be installing 9.2 shortly and having a play around with this -
I'll report back what I think.
An Architect's View -- http://www.corfield.org/blog/
Macromedia DevCon 2002, October 27-30, Orlando, Florida
Architecting a New Internet Experience
Register today at http://www.macromedia.com/go/devcon2002
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
