After creating an XSQL file and adding tags, you can view the raw XML data or format the XML data with a style sheet.

Please select an XSQL tag to see a complete description, syntax and examples.

You can create XML based clients for business components using XSQL servlet. XSQL servlet allows you to easily get data in and out of the database in XML format. The following procedure shows how to bind an XSQL client to a business components project you have already created, using the ViewObject Show tag to display the view object's data in XML format. You could also use the ViewObject Update tag to process inserts, updates, and deletes to a view object.

To connect your XSQL Servlet to your database you must create a database connection in the XSQLConfig.xml file. This file is located in C:\oracle\ora90\xdk\admin\XSQLConfig.xml (this path may vary depending on where you install your Oracle9i database). To set up your database connection you must edit the tag, located approximately three quarters of the way down the file. Your tag should look similar to the following:

All XSQL tags can be inserted by selecting them from the Component Palette, as described below. You can also insert XSQL tags by typing them in the file. Code Insight is available for XSQL tags.

The Oracle XSQL Pages publishing framework is an extensible platform for easily publishing XML information in any format you desire. It greatly simplifies combining the power of SQL, XML, and XSLT to publish dynamic web content based on database information. Using the XSQL publishing framework, anyone familiar with SQL can create and use declarative templates called "XSQL pages" to:

As the Internet drives an explosive demand for flexible information exchange, more and more application developers need to put their business data to work over the Web. Developers require standards-based solutions to this problem and SQL, XML, and XSLT are the standards that can get the job done in practice.

The Oracle8i database provides components and utilities, including the XSQL Servlet, that allow you to take advantage of XML technology in your database applications. This article is an excerpt from the Oracle XML Handbook that explains how to do this.

A tool to run Mobile XSQL & BC4J Applications from JDeveloper 3.1.

XSQL combines the power of XML and SQL to provide a language and database independent means to store and retrieve SQL queries and their results.

A potential security vulnerability in Oracle XSQL Servlet has been discovered when using stylesheets as URL parameters which permits the execution of arbitrary Java code on the Oracle 8.1.7.0.0 database server with elevated privileges. This vulnerability was discovered in Oracle8i, Release 8.1.7.0.0, Enterprise Edition running Oracle Internet Application Server (iAS) and XSQL Servlet, Release 1.0.0.0, on MS Windows 2000. It also exists in XSQL releases 1.0.1.0 to 1.0.3.0 on all platforms.

The Oracle XSQL Pages publishing framework is an extensible platform for easily publishing XML information in any format you desire. It greatly simplifies combining the power of SQL, XML, and XSLT to publish dynamic web content based on database information.

The Oracle XSQL Pages Publishing Framework is an extensible platform for easily publishing XML information in any format displayable or transferrable on the Internet. By combining the power of SQL, XML, and XSLT, it greatly simplifies publishing dynamic web content based on database information.

The ability to transfer information from one database to another is vital to DBAs. XSQL provides a way to easily transfer stored information, by generating SQL INSERT statements.

After a long and intensive beta testing period xSQL Object is finally here. xSQL Object allows you to compare, script and synchronize SQL Server databases, tables, stored procedures, views, user defined data functions etc. quickly and painlessly. This has been a joint effort of our development team and our wonderful early adapters that have provided invaluable feedback throughout the development process.

The Oracle XSQL Pages publishing framework is a free and simple, but powerful tool for DBA's and developers who know SQL to easily publish database information in any number of formats. It's something I'm the lead developer on at Oracle, in addition to working on the JDeveloper and BC4J products, so I'm a little biased, but I think it's keep-it-simple-stupid! design philosophy has made it popular with our users, which makes me happy. Among lots of more fundamental Oracle and XML technical stuff, my Building Oracle XML Applications book also includes extensive coverage of using XSQL pages to build applications that leverage SQL, XML, and XSLT.

XSQL, the combination of XML and SQL, aims to be a complete query and result storage system. You can store your database queries in XML, convert them to actual SQL, issue the query, and receive the results in XML format. Currently this functionality is available only in Perl through the XML::Generator::DBI module and XSQL patches.

Steve Muench of Oracle has announced an update of their SQL+XML+XSLT publishing framework "XSQL Pages", a freely available Java servlet engine.

The first prototype screen contains the five most recently posted jobs that match the user's search criteria. The value for the search string would be supplied when the user completes the WML form listed in example 1, although it could also be stored in one of a catalogue of user search profiles stored in the database in a real system. The screen only needs to access one table in the database - the JOB table and present an initial WML deck that contains a top level card with each job title forming a hyperlink pointing to a related card containing further details about the job. This allows the user to have a quick view of the jobs that have been posted and to retrieve more details about interesting-looking jobs quickly without resubmitting a new request.

XML was first introduced in 1996 and quickly spread into various information technology areas. With ongoing introduction and further specification of the new technology, XML documents became more and more complex and bigger in size.