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