Hello Expert,
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:
<Employee>
<EMPID>1</EMPID>
<EMPNAME>AAA</EMPNAME>
<EMPSALARY>2000.00</EMPSALARY>
<DEPTID>1</DEPTID>
</Employee>
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
please help..
Thanks in advance...
reagrds,
Avi