Re: Oracle 10g XML
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 26 Jan 2008 11:30:23 +0100
Message-ID: <479B0BBF.3030302@gmail.com>
>
> Yes. See XML DB Developer's Guide for details. There are plenty of
> options: SQL/XML, Oracle's extensions to it, DBMS_XMLGEN package,
> DBUriType type, SYS_XMLGEN() and SYS_XMLAGG() SQL functions, and more.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Date: Sat, 26 Jan 2008 11:30:23 +0100
Message-ID: <479B0BBF.3030302@gmail.com>
Vladimir M. Zakharychev schrieb:
> On Jan 26, 12:41 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>> Hi, >> >> I'm sure this can be done, but I want to verify it. >> >> Can you output XML from the result of a query or set of data??? >> >> Thanks!
>
> Yes. See XML DB Developer's Guide for details. There are plenty of
> options: SQL/XML, Oracle's extensions to it, DBMS_XMLGEN package,
> DBUriType type, SYS_XMLGEN() and SYS_XMLAGG() SQL functions, and more.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Just a small addition, for any new development oracle (well to be precise, Mark Drake, who is product manager of XMLDB) encourage to use whenever possible SQL/XML Operators instead of DBMS_XMLGEN http://forums.oracle.com/forums/message.jspa?messageID=2273576#2273576 (the OTN XMLDB forum itself is an excellent source of examples to generate XML from relational data)
Best regards
Maxim Received on Sat Jan 26 2008 - 04:30:23 CST