RE: Question re inserting hashed strings (I think)

Cool trick, it works, problem solved. Thank you.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Friday, April 24, 2009 6:17 PM
To: William Wagman
Cc: Bobak, Mark; Oracle-L Freelists
Subject: Re: Question re inserting hashed strings (I think)

On Fri, Apr 24, 2009 at 4:00 PM, William Wagman <wjwagman_at_ucdavis.edu<mailto:wjwagman_at_ucdavis.edu>> wrote: Mark,

Ok, that's cool, I did not know about that. When I do that I get what you indicated -

SQL> select dump(password) from axis.tenants;

DUMP(PASSWORD)

Is there a way, having this information to insert this information back into the password field?

insert into TABLE(COLUMN) values(chr(1) || chr(2) || chr(3) || ...)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l