i want to knw that how to decrypt stored password in oracle database..

What password do you mean ? If you mean that from a user, then no, you can't (it's a hash).

PASSWORD USERNAME
------------------------------ ------------------------------
F894844C34402B67 SCOTT


that password i want to decrypt..

Where does that come from, did you insert that yourself (post your table structure and insert query), or is it an Oracle user (then see previous answer) ?

Where does that come from, did you insert that yourself (post your table structure and insert query), or is it an Oracle user (then see previous answer) ?

select username,password from dba_users where username='SCOTT';

this is the query that actual password stored in that dba_users master table..

Like I said before, you cannot decrypt that password because it is a hash.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.