1. Login to your Oracle SQL and execute below command. This will list all users from the Oracle.
SQL> select USERNAME from dba_users; USERNAME ------------------------------ SAPSR3 SYS OPS$SIDADM OPS$ORASID ITSITI SYSTEM 6 rows selected.
2. For a specified users, execute below command.
SQL> select USERNAME from dba_users where USERNAME='SYSTEM'; USERNAME ------------------------------ SYSTEM
