XML Query (XQuery) Language

• XQ-S-2 fn:collection usage example
• XQ-S-2A collection usage example
• XQ-S-3 document usage example
• XQ-S-4 document usage example

XMLELEMENT, XMLAGG and other SQL-XML composing functions

• SX-E-0 XMLELEMENT() function.
• SX-E-1 XML element without content
• SX-E-2 XML element with a text content
• SX-E-3 XML element with attributes
• SX-E-4 XML element with attribute, a text content and a sublement
• SX-E-5 XML element with two nested subelements
• SX-E-6 XML element with XMLFOREST() function call as parameter
• SX-E-7 XML element with XMLCONCAT() function call as parameter
• SX-E-8 XML element with XMLAGG() function call as parameter
• SX-E-9 XML element with the entity objects as parameters
• SX-F-1 XMLFOREST() function
• SX-G-1 XMLCONCAT() function
• SX-H-1 XMLAGG() function

XML Examples

• XS-S-1 Freetext index over XML data
• XS-S-2 Freetext index over persistent XML data
• XS-S-3 Search on freetext indexed data
• XS-S-4 Search on freetext indexed data using xcontains predicate
• XS-S-5 Storing of XSLT results
• XS-S-6 Applying the XPATH expression
• XS-S-7 Passing an XML entity as parameter to the XSL-T style-sheet
• XS-S-8 Building a freetext index using a custom PL indexing hooks
• XS-S-9 Making the resultsets with xpath_eval() function

Using Annotated XSD Schemas for Creating XML Views

• MS-A-1 Mapping Schemas
• MS-A-2 Using sql:relation and sql:field
• MS-A-3 Using sql:relationship to Specify Relationships
• MS-A-3A Using sql:relationship to Specify Relationship on an attribute
• MS-A-3B Using sql:relationship to Specify Relationship on multiple elements.
• MS-A-4 Using sql:is-constant for creating constant elements
• MS-A-5 Filtering Values by Using sql:limit-field and sql:limit-value

Using XPath queries to XML views

• XP-V-1 Using XPath queries to XML views. Overview.
• XP-V-2 Using XPath queries with options.
• XP-V-3 Using XPATH in SQL Queries and Procedures.

Updategrams

• XS-U-1 Updategrams
• XS-U-2 Parameter usage in updategrams
• XS-U-3 Row Insertion and Report Generation using XML Templates

FOR XML SQL Clause

• XS-F-1 FOR XML SQL Clause
• XS-F-2 FOR XML EXPLICIT SQL statements