Get oracle username for in format Oracle Database
SELECT '(' || LISTAGG('''' || username || '''', ',') WITHIN GROUP (ORDER BY username) || ')' AS usernames FROM dba_users WHERE default_tablespace = 'USER_TEMP';
username1,username2,username3,username4
Comments
Post a Comment