posted 15 years ago
hi,
Can it possible to get the results in XML format when it is queried agnist MySql data base.
I have a sample query of DB2 data base, where you can get the result in XML formatted way:
SELECT REC2XML (0.001,'COLATTVAL','row',tabname,colname,typename,length,default,nulls) as "xmlData" FROM syscat.columns
here the REC2XML function makes the XML format data after querying from DB2 database.
Can any one help me, how it can be done it in MySql and Oracle database.
Thanks & Regards,
Pankaj Patro