Hi my requirement is as follows..
1. Query the Oracle EMP Table and get the records as XML.
2. Process this XML using JSP/Servlets
3. Display those records in <Table> format in the browser by applying XSL.
4. The idea is to sort the resultset as per the user wish in the browser level itself. User can sort it by EMpID, EMP Name or DeptNo etc...so that i can avoid the DB connection for each sort.
I tried to get the records using OracleXMLQuery class using java but it returned a XML string. I dont know how to process this XML string...and where to strore this string
It would be geatful if anyone can give me a code for this..
Regards,
Raja.