Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Overview of this book

Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface

Overview of XSQL Tags


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