System Tables Data Dictionary Oracle PLSQL Tutorial

SQL>  select
  2        Username,         /*Username*/
  3        Password          /*Encrypted password*/
  4  from DBA_USERS
  5  where Username in ('MCGREGOR','THUMPER','OPS$FARMER');
SQL>