SELECT ID,
XMLELEMENT( NAME product_info,
            XMLELEMENT( NAME item_name, Products.name ),
            XMLELEMENT( NAME quantity_left, Products.Quantity ),
            XMLELEMENT( NAME description, Products.Size || ' ' ||
                        Products.Color || ' ' || Products.name )
          ) AS results
FROM Products
WHERE Quantity > 30;

SELECT ID, XMLELEMENT( NAME product_type, 'hat' )
FROM Products
WHERE Name IN ( 'Baseball Cap', 'Visor' );

SELECT ID, XMLELEMENT( NAME item_description,
                       XMLATTRIBUTES( Name,
                                      Color,
                                      UnitPrice )
                      ) AS item_description_element
FROM Products
WHERE ID > 400;

SELECT ID, XMLELEMENT( NAME item_description,
                       XMLATTRIBUTES ( Color AS color,
                                      UnitPrice AS price ),
                       Products.Name
                     ) AS products
FROM Products
WHERE ID > 400;

CREATE OR REPLACE PROCEDURE "DBA"."http_header_example_with_table_proc"()
RESULT ( res LONG VARCHAR )
BEGIN
    DECLARE var LONG VARCHAR;
    DECLARE varval LONG VARCHAR;
    DECLARE I INT;
    DECLARE res LONG VARCHAR;
    DECLARE htmltable XML;
    SET var  = NULL;
loop_h:  
    LOOP
        SET var = NEXT_HTTP_HEADER( var );
        IF var IS NULL THEN LEAVE loop_h END IF;
        SET varval = http_header( var );
        -- ... do some action for <var,varval> pair...
        SET htmltable = htmltable || 
            XMLELEMENT( name "tr", 
            XMLATTRIBUTES( 'left' AS "align", 'top' AS "valign" ),
            XMLELEMENT( name "td", var ),
            XMLELEMENT( name "td", varval ) )  ;
    END LOOP;

    SET res = XMLELEMENT( NAME "table",
        XMLATTRIBUTES( '' AS "BORDER", '10' as "CELLPADDING", '0' AS "CELLSPACING" ),

        XMLELEMENT( NAME "th", 
            XMLATTRIBUTES( 'left' AS "align", 'top' AS "valign" ),
            'Header Name' ), 
                
        XMLELEMENT( NAME "th", 
             XMLATTRIBUTES( 'left' AS "align", 'top' AS "valign" ),
             'Header Value' ),
           
        htmltable);
    SELECT res;
END;