how can I get oracles data and change it into xml?# XML - WWW明日之星
q*o
1 楼
how can I get oracles data and change it into xml?
who can give me some samples like this case? thanks!
who can give me some samples like this case? thanks!
H*o
2 楼
I posted before:
example query of sqlserver
SELECT *
FROM Customers
FOR XML AUTO
the result is a full XML document
【在 q****o 的大作中提到】
: how can I get oracles data and change it into xml?
: who can give me some samples like this case? thanks!
w*h
3 楼
FOR XML is only in SQL Server.
Different relational database system has different XML support.
Oracle 9i does have quite some XML support. It has a XML datatype, and
provide quite some system functions to compose XML.
But I think the question may be two:
How to compose data from relational table into hirarchial XML documents,
and how to map XML schema into relational database.
For the latter, there is no fast way, you have to do it by hand.
【在 H********o 的大作中提到】
:
: I posted before:
: example query of sqlserver
: SELECT *
: FROM Customers
: FOR XML AUTO
: the result is a full XML document
Different relational database system has different XML support.
Oracle 9i does have quite some XML support. It has a XML datatype, and
provide quite some system functions to compose XML.
But I think the question may be two:
How to compose data from relational table into hirarchial XML documents,
and how to map XML schema into relational database.
For the latter, there is no fast way, you have to do it by hand.
【在 H********o 的大作中提到】
:
: I posted before:
: example query of sqlserver
: SELECT *
: FROM Customers
: FOR XML AUTO
: the result is a full XML document
H*o
4 楼
A friend mentioned there's an easy way to "map XML schema
into relational database", but he didn't say how to do it.
We need to do some research...
【在 w*****h 的大作中提到】
: FOR XML is only in SQL Server.
: Different relational database system has different XML support.
: Oracle 9i does have quite some XML support. It has a XML datatype, and
: provide quite some system functions to compose XML.
: But I think the question may be two:
: How to compose data from relational table into hirarchial XML documents,
: and how to map XML schema into relational database.
: For the latter, there is no fast way, you have to do it by hand.
b*k
5 楼
XSLT?
【在 H********o 的大作中提到】
:
: A friend mentioned there's an easy way to "map XML schema
: into relational database", but he didn't say how to do it.
: We need to do some research...
【在 H********o 的大作中提到】
:
: A friend mentioned there's an easy way to "map XML schema
: into relational database", but he didn't say how to do it.
: We need to do some research...
l*n
6 楼
data binding
【在 b***k 的大作中提到】
: XSLT?
【在 b***k 的大作中提到】
: XSLT?
相关阅读