Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Wednesday, August 28, 2013

Generate XML Data with SQL query using XML tags

<?xml version="1.0" encoding="WINDOWS-1252" ?>
- <dataTemplate name="XXXXXSMSN" description="XXX Signup Notification" version="1.0">
- <parameters>
<parameter name="P_ORDER_HEADER_ID" dataType="NUMBER" />
</parameters>
- <dataQuery>
- <sqlStatement name="Q_MAIN">
<![CDATA[ 
 select ooh.CUST_PO_NUMBER
                            ,ooh.ORDER_NUMBER
                            ,TO_CHAR(ooh.ORDERED_DATE, 'MM/DD/YYYY')   ORDERED_DA                        from OE_ORDER_HEADERS_ALL   ooh
                      where ooh.header_id          = :P_ORDER_HEADER_ID
]]>
</sqlStatement>
</dataQuery>
</dataTemplate>
Posted by at
Labels:

1 comment:

Subscribe to: Post Comments (Atom)