Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 07:55 PM - edited 01-08-2025 08:03 PM
you can share a sample or mocked value, how your xml looks?
mean while you can give a try with below query
SELECT xpath_string(MyColumn.value, '/XMLData/Values/ValueDefinition[@colID="10"]/@Value')[1] as Remarks
Regards,
Hari Prasad
