By parsing JSON array, you get values in brackets and double quotas and might need to make the string more human readable. Regular expression REGEXP_REPLACE can be used for it in your sql. Input string: [“Blue”], [“Pink”], [“Black”] Output string: Blue; Pink; Black Action: Get rid of brackets with double quotas and replace comma by…