Re: XML from tables

From: Harri Kaukovuo <harri.kaukovuo4_at_nic.fi>
Date: 16 Nov 2002 08:51:06 GMT
Message-ID: <ar50tq$rtg$1@news1.songnet.fi>

Oracle9.2 has plenty of possibilities to generate the XML you needed. For example use the new SQL/XML functions implemented in SQL:

- XMLELEMENT
- XMLFOREST
- XMLAGG
- XMLCONCAT
- XMLTRANSFORM

...

See the 9iDB rel 2 SQL documentation for further info.

• Harri

"Amin Emami" <Amin_Emami_at_yahoo.com> wrote in news:ar3kmu$eosc4$1_at_ID-101160.news.dfncis.de:

> Dear Yasenko,
> It was absolutely general ! But we're working on Oracle 9i2 database,
> with J2EE . I'm looking for a way to have my answer at the database
> side.
>
> yours,
> Amin Emami
>
>
> "Yasenko Yorgich" <elcaro_at_softhome.net> wrote in message
> news:ba8b6976.0211130205.589e0d3f_at_posting.google.com...

>> Best suggestion is to start at
>> http://otn.oracle.com/tech/xml/content.html
>>
>>
>> >
>> > How can I make XML structures and data directly from oracle talbes
>> > ? 
>> >
>>
>> This question doesn't say much about your intentions, which language
>> you use (Java, perl, VB etc), what release of Oracle db, what OS etc
>> etc

-- 
-----------------------------------------------------------------------
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4

Received on Sat Nov 16 2002 - 02:51:06 CST