Re: XML extensions to SQL

"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:EcWna.3$bd1.86_at_news.oracle.com...
> I would be interested to know if there is a serious opposition to SQL XML
> extensions in the ANSI committee. For example would the noncense like this
>
> SELECT XMLElement("Product",XMLAttributes(prod_id),
> XMLAgg( XMLElement("Sales",XMLAttributes(cust_id,time_id),
> XMLForest(quantity_sold,amount_sold)))) AS result
> FROM sales_tab s
> GROUP BY prod_id;
>
> ever see a day light?
>
>

Maybe you know is this already:

http://www.sqlx.org/

For some early implementations you can find a few chapters that cover DB2, Oracle 9i and MS SQL Server:

http://www.awprofessional.com/titles/0201844524/

vr

akmal chaudhri Received on Fri Apr 18 2003 - 22:08:02 CEST