get list of users in oracle code example

Example: oracle list users

SELECT * FROM DBA_USERS WHERE USERNAME = 'MY_USER';