Contribute from: Tim Hartman (TX3)

DB TYPE:           ORACLE 11g

Query:

SELECT listagg(''''||user_name||'''',',')

WITHIN GROUP (ORDER BY user_name) as SA

FROM users

where user_id in (SELECT ur_user_id as SA FROM users_roles)