SQL query to extract XML data from Oracle table

Following query will help to extract the information of xml element from stored XML data in Oracle table.

select
	XMLTYPE(ad.ad_profile).EXTRACT('//bankId').getStringVal(), 
	XMLTYPE(ad.ad_profile).EXTRACT('//altDesc').getStringVal(), 
	DECODE(ad.adsta_id, 1, 'Success', 2, 'Failure')
from 
	alert_delivery ad
where 
	ad.altd_id in (1001,1002)
group by 
	XMLTYPE(ad.ad_profile).EXTRACT('//bankId').getStringVal(), 
	XMLTYPE(ad.ad_profile).EXTRACT('//altDesc').getStringVal(), 
	ad.adsta_id;