Same above scenario i have...i have a table in which one column xmldata(having datatype xml) contain data in xml format, as given below:
Now i have to read this xml data and display it with respective column names..like
EMPID EMPNAME EMPSALARY DEPTID
1 AAA 2000.00 1
Thanks in advance...