RE: Question re inserting hashed strings (I think)
Date: Mon, 27 Apr 2009 12:40:03 -0700
Cool trick, it works, problem solved. Thank you.
Univ. of California at Davis
IET Campus Data Center
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;
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) || ...)
Certifiable Oracle DBA and Part Time Perl Evangelist