Executes a SQL DML statement or PL/SQL anonymous block.

This sample application demonstrates the use of the XSQL servlet to connect to a BC4J middle tier project and query and update the database. It also shows you how you can apply different stylesheets to the same document and view the results on an HTML browser or a cell phone simulator.

Executes a PL/SQL stored procedure that uses the OWA packages to generate XML content, and includes the resulting XML.

JDeveloper's XML Editor supports syntax highlighting, Structure window view, and the Property Inspector. You can also select tags from the Component Palette to insert in your pages while you are editing.

An action handler in an XSQL page is a Java class that gets invoked to perform a specific task. There are prebuilt action handlers for various tasks such as setting cookies, applying style sheets, performing queries against databases, etc. However, if you choose to perform some operation which is not provided by the built-in action handlers, then you can write what is called a custom action handler. A custom action handler is a Java class that can be invoked from an XSQL page just as easily as a predefined action handler.

After you have completed your XSQL file, you should check your XML syntax and then run it.

You can check your XSQL file to determine if it is a well-formed XML document and if not, to find any errors.

You can create XML based clients for XSQL servlets using XSQL tags. XSQL servlets allow you to easily get data in and out of the database in XML format. The following procedure shows how to use the XSQL Query tag to display data.

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.

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.

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.

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 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.