• Hi Friend,

    thanks for your support.

    but i already got this output..

    using the below simple single query..

    select * from Xml_Export listing for xml auto ,elements ,ROOT('Listings')

    but i need above result with below mentioned line that line should be first line of the output...

    <?xml version="1.0" encoding="UTF-8" ?>

    and aslo out put should be like Above { XML hyperling } is must..

    Thanks & Regards,

    K.D.Saravanan MCA