Hi,
In one of the tables has xmltype datatype columns and this column having below xml data.
<Customers>
<Customer>
<FirstName>Kevin</FirstName>
<LastName>Goff</LastName>
<City>Camp Hill</City>
</Customer>
<Customer>
<FirstName>Steve</FirstName>
<LastName>Goff</LastName>
<City> Philadelphia </City>
</Customer>
</Customers>
From the string, i want to only column name from these string.
sample output :
FirstName
LastName
City.
Thanks,
Michael Holding
Michael Holding ...
Go to the complete details ...