<?xml version="1.0"?> <!-- creditcardauth.xsql --> <?xml-stylesheet type="text/xsl" href="rowset-to-creditcardauth.xsl"?> <xsql:query xmlns:xsql="urn:oracle-xsql" connection="xmlbook" max-rows="1" > SELECT card_number,exp_month,exp_year,amount, currency,merchant_id, /* Use TO_CHAR to format date as we want it in resulting XML */ TO_CHAR(request_date,'DD-MM-YYYY HH24:MI:SS') as request_date FROM authorization_request WHERE request_id = {@id} </xsql:query> |