Example 8-8: XSQL page to validate airport codes

<?xml version="1.0"?>
<xsql:query connection="xmlbook" max-rows="1" rowset-element="Ok"
            row-element="Airport" xmlns:xsql="urn:oracle-xsql">

 SELECT tla "Code", description "Description"
	 FROM AIRPORT
	WHERE tla = UPPER('{@code}')

  <xsql:no-rows-query max-rows="4" rowset-element="Error" row-element="Airport">

    SELECT tla "Code", description "Description"
	    FROM AIRPORT
     WHERE UPPER(description) LIKE UPPER('%{@code}%')
     ORDER BY 2

  </xsql:no-rows-query>
</xsql:query>