Need SQL query to split the data based on Source Bank name

Hi All,

We have a table named as PAY_FILE_DETAILS in Fusion Cloud. In that table we have FILE_FRAGMENT CLOB COLUMN is having data in XML format. In that CLOB column we have data like HRMS Employees and correpsonding source bank details. We have two source bank details. Each employee is assigned to any one source bank.Now we have to split the data based on source bank in the same XML format.

I need SQL query to read the FILE_FRAGMENT clob column(XML) and split the data based on Source Bank Name.

Ex: As of now in a CLOB column we have total 10 employees. 5 employees are related to "ESS Payroll VS" and 5 employees are related to "ESS Payroll"