Oracle XML SQL Utility 2.1 Beta

Date:      Thu, 16 Nov 2000 16:07:36 -0800
From:      Steve Muench <smuench@us.oracle.com>
To:        xml-dev@lists.xml.org
Subject:   ANN: Oracle XML SQL Utility 2.1 Beta

Release 2.1.0 Beta of the Oracle XML SQL Utility is now available on Oracle Technet web site.

http://technet.oracle.com/tech/xml

Key new features include:

SAX2 output from any SQL query for handling XML query output of arbitrary size in custom programs or SAX filters.
Full support for any JDBC driver, removing previous restrictions on the XML->to->DB insert/update/delete functionality which formerly only worked with the Oracle JDBC driver. The SQL->to->XML direction continues to support all drivers as it did before.
Initial XML Schema support, allowing you to produce inline XML Schema for the XML result of any SQL query
New support for retrieving data as XML attributes instead of elements by using standard SQL column aliasing.

       e.g. SELECT FOO as "@foo", BAR as "bar" FROM BAZ

       produces:

           <rowset>
              <row foo="foovalue">
                <bar>barvalue</bar>
              </row>
           </rowset>

Enjoy.

Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/

Prepared by Robin Cover for The XML Cover Pages archive.

SEARCH Advanced Search ABOUT Site Map CP RSS Channel Contact Us Sponsoring CP About Our Sponsors NEWS Cover Stories Articles & Papers Press Releases CORE STANDARDS XML SGML Schemas XSL/XSLT/XPath XLink XML Query CSS SVG TECHNOLOGY REPORTS XML Applications General Apps Government Apps Academic Apps EVENTS LIBRARY Introductions FAQs Bibliography Technology and Society Semantics Tech Topics Software Related Standards Historic	Oracle XML SQL Utility 2.1 Beta Date: Thu, 16 Nov 2000 16:07:36 -0800 From: Steve Muench <smuench@us.oracle.com> To: xml-dev@lists.xml.org Subject: ANN: Oracle XML SQL Utility 2.1 Beta Release 2.1.0 Beta of the Oracle XML SQL Utility is now available on Oracle Technet web site. http://technet.oracle.com/tech/xml Key new features include: SAX2 output from any SQL query for handling XML query output of arbitrary size in custom programs or SAX filters. Full support for any JDBC driver, removing previous restrictions on the XML->to->DB insert/update/delete functionality which formerly only worked with the Oracle JDBC driver. The SQL->to->XML direction continues to support all drivers as it did before. Initial XML Schema support, allowing you to produce inline XML Schema for the XML result of any SQL query New support for retrieving data as XML attributes instead of elements by using standard SQL column aliasing. e.g. SELECT FOO as "@foo", BAR as "bar" FROM BAZ produces: <rowset> <row foo="foovalue"> <bar>barvalue</bar> </row> </rowset> Enjoy. Steve Muench, Lead XML Evangelist & Consulting Product Manager BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG Author "Building Oracle XML Applications", O'Reilly http://www.oreilly.com/catalog/orxmlapp/ Prepared by Robin Cover for The XML Cover Pages archive.