select password
from over_his_shoulder
where he_does_not_see_me = 'TRUE'
  and he_types_too_fast = 'FALSE';

SQL> create User a identified by "a";

User created.

SQL> create User b identified by "a";

User created.

SQL> select dbms_metadata.get_ddl('USER','A') from dual;

DBMS_METADATA.GET_DDL('USER','A')
--------------------------------------------------------------------------------

   CREATE USER "A" IDENTIFIED BY VALUES 'S:298EDEE1721E71B950D55CCB9ABA7EE5C596E
A6B0CCFF098E88889B98BD5;AFCC9478DFBF9029'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"



SQL> select dbms_metadata.get_ddl('USER','B') from dual;

DBMS_METADATA.GET_DDL('USER','B')
--------------------------------------------------------------------------------

   CREATE USER "B" IDENTIFIED BY VALUES 'S:25E85C1466288EE377681D131DF1920B33448
CD4108F8DDFC580A3315A39;9017AAA5BF2D9732'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"



SQL> select name, password, spare4 from sys.user$ where name ='A'
  2  ;

NAME                           PASSWORD
------------------------------ ------------------------------
SPARE4
--------------------------------------------------------------------------------
A                              AFCC9478DFBF9029
S:298EDEE1721E71B950D55CCB9ABA7EE5C596EA6B0CCFF098E88889B98BD5


SQL> select password,username from dba_users
  2  where length(username)=1;

PASSWORD                       USERNAME
------------------------------ ------------------------------
                               A
                               B

SQL>

SQL> desc user$
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 USER#					   NOT NULL NUMBER
 NAME					   NOT NULL VARCHAR2(30)
 TYPE#					   NOT NULL NUMBER
 PASSWORD					    VARCHAR2(30)
 DATATS#				   NOT NULL NUMBER
 TEMPTS#				   NOT NULL NUMBER
 CTIME					   NOT NULL DATE
 PTIME						    DATE
 EXPTIME					    DATE
 LTIME						    DATE
 RESOURCE$				   NOT NULL NUMBER
 AUDIT$ 					    VARCHAR2(38)
 DEFROLE				   NOT NULL NUMBER
 DEFGRP#					    NUMBER
 DEFGRP_SEQ#					    NUMBER
 ASTATUS				   NOT NULL NUMBER
 LCOUNT 				   NOT NULL NUMBER
 DEFSCHCLASS					    VARCHAR2(30)
 EXT_USERNAME					    VARCHAR2(4000)
 SPARE1 					    NUMBER
 SPARE2 					    NUMBER
 SPARE3 					    NUMBER
 SPARE4 					    VARCHAR2(1000)
 SPARE5 					    VARCHAR2(1000)
 SPARE6 					    DATE