In this section, we will discuss the different XSQL tags that may be specified in an XSQL page. The root element in an XSQL page is<page>
. Some of the XSQL tags are discussed in following table. XSQL tag attributes are optional unless specified to be required in the table.
XSQL Tag |
Description |
Attributes |
---|---|---|
xsql:query |
Runs an SQL query and includes result set as XML. |
Refer to the second Table |
xsql:dml |
Runs a DML SQL statement or a PL/SQL anonymous block. |
name (required): Name of page level parameter. ignore-empty-value: Specifies if empty value ("") should be ignored. Default is 'no'. value:Param value. |
xsql:set-page-param |
Sets a page-level parameter. |
name (required): Name of page level parameter. ignore-empty-value: Specifies if empty value ("") should be ignored. Default is 'no'. value:Param value. |
xsql:set-session-param |
Sets a session level param. |
Same as xsql:set-page-param. |
xsql:set-stylesheet-param |
Sets XSLT stylesheet param. |
Same as xsql... |