SQL> SQL> DECLARE 2 password VARCHAR2(60); 3 BEGIN 4 IF ora_dict_obj_type = 'USER' THEN 5 password := ora_des_encrypted_password; 6 dbms_output.put_line('password:'||password); 7 END IF; 8 END; 9 / PL/SQL procedure successfully completed. SQL> SQL> SQL> SQL>