Please select an XSQL tag to see a complete description, syntax and examples.
xsql:delete-request—Deletes the rows represented in the XML document that has been posted in the request.
xsql:dml—Executes a SQL DML statement or PL/SQL anonymous block.
xsql:include-owa—Executes a PL/SQL stored procedure that uses the OWA packages to generate XML content, and includes the resulting XML.
xsql:include-param—Includes XML representing the name and value of a specified parameter.
xsql:include-request-params—Includes an XML fragment representing the names and values of all HTTP parameters, cookies, and session variables.
xsql:include-xml—Includes external XML content by specifying an absolute, relative, or parameterized URL.
xsql:include-xsql—Includes the XML output of another XSQL page.
xsql:insert-param—Inserts the value of a parameter into a database table or view.
xsql:insert-request—Inserts the (optionally transformed) XML document that has been posted in the request into a database table or view.
xsql:query—Executes an arbitrary SQL statement and includes its result set in canonical XML format.
xsql:ref-cursor-function—Executes an arbitrary stored function returning a REF CURSOR and includes the result set in canonical XML format.
xsql:set-cookie—Sets the value of an HTTP Cookie, and optionally specifies the maximum age and domain of the cookie.
xsql:set-page-param—Sets the value of a page-level parameter.
xsql:set-session-param—Sets the value of a session-level parameter.
xsql:set-stylesheet-param—Sets the value of a top-level XSLT style sheet parameter.
xsql:update-request—Updates the rows represented in the (optionally transformed) XML document that has been posted in the request.
xsql:action handler="oracle.jbo.xsql.ViewObject"—Renders canonical XML data from a business components view object and optionally any number of levels of related, view-linked view objects.
xsql:action handler="oracle.jbo.xsql.UpdateViewObject"—Processes inserts, updates, and deletes to rows in a view object and any number of levels of related, view-linked view objects, based on an optionally transformed XML document.
Creating an XSQL File
Adding XSQL Tags