Hi All
I have a requirement to convert the data from sql to xml using
java.
For Example If i write a query like this....
"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.tables WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME ike 'tbl_sis_%'"
I will be getting following two xml and two xsd files....
BASE_TABLE.xml
tbl_sis_products.xml
BASE_TABLE.xsd
tbl_sis_products.xsd
It would be great help if some one gives some idea on it.
Thanks
Tuna