Background: Oracle 11g on Windows environment
I am working on a query that will provide a list all usernames in my system where the username and password are the same. The problem is the passwords are not plan text so the query give zero result.
Is there any other way I can do query this problem?
Example:
SELECT name, user#, password from sys.user$
WHERE name = password;