dbTalk Databases Forums  

Oracle 10g XML

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Oracle 10g XML in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
amerar@iwc.net
 
Posts: n/a

Default Oracle 10g XML - 01-25-2008 , 03:41 PM







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!


Reply With Quote
  #2  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 03:02 AM






On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) net> wrote:
Quote:
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


Reply With Quote
  #3  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 03:02 AM



On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) net> wrote:
Quote:
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


Reply With Quote
  #4  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 03:02 AM



On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) net> wrote:
Quote:
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


Reply With Quote
  #5  
Old   
Vladimir M. Zakharychev
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 03:02 AM



On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) net> wrote:
Quote:
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


Reply With Quote
  #6  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 04:30 AM



Vladimir M. Zakharychev schrieb:
Quote:
On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) 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/mess...273576#2273576
(the OTN XMLDB forum itself is an excellent source of examples to
generate XML from relational data)

Best regards

Maxim


Reply With Quote
  #7  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 04:30 AM



Vladimir M. Zakharychev schrieb:
Quote:
On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) 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/mess...273576#2273576
(the OTN XMLDB forum itself is an excellent source of examples to
generate XML from relational data)

Best regards

Maxim


Reply With Quote
  #8  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 04:30 AM



Vladimir M. Zakharychev schrieb:
Quote:
On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) 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/mess...273576#2273576
(the OTN XMLDB forum itself is an excellent source of examples to
generate XML from relational data)

Best regards

Maxim


Reply With Quote
  #9  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: Oracle 10g XML - 01-26-2008 , 04:30 AM



Vladimir M. Zakharychev schrieb:
Quote:
On Jan 26, 12:41 am, "ame... (AT) iwc (DOT) net" <ame... (AT) iwc (DOT) 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/mess...273576#2273576
(the OTN XMLDB forum itself is an excellent source of examples to
generate XML from relational data)

Best regards

Maxim


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.