List of all the Oracle application database schemes

List of all the application database schemes

SELECT  DISTINCT USERNAME , CREATED

FROM DBA_USERS;