select sla_id, b.email_id,rule_expression,escalation_id,type from ( WITH DATA AS (select mail_to,rule_expression,sla_id,escalation_id, type from T_PROJECT_SLAS_ESCALATIONs a /*where a.type = 'Response'*/ /*and sla_id in (42)*/ /* order by sla_id asc*/) SELECT trim(regexp_substr(mail_to, '[^,]+', 1, LEVEL)) mail_to, rule_expression,sla_id,escalation_id,type FROM DATA CONNECT BY LEVEL <= regexp_count(mail_to, ',') + 1) slas_data, tas.t_users b where mail_to=b.user_name order by email_id