How to fetch a comma separated string into separate columns in Oracle fusion

Summary:

We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK".
When we have multiple approvers for a transaction and those will appear in the "Approvers" column as "Comma - Separated values".
Ex: (awilson, lkilfeather)
So, we need to separate them as a separate column.
How to achieve this? Please help us!

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SCRIPT:
SELECT IDENTIFICATIONKEY, APPROVERS FROM
FA_FUSION_SOAINFRA.WFTASK