RE: Question re inserting hashed strings (I think)
- From: William Wagman <wjwagman@xxxxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>
- Date: Mon, 27 Apr 2009 12:40:03 -0700
Jared,
Cool trick, it works, problem solved. Thank you.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
From: Jared Still [mailto:jkstill@xxxxxxxxx]
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@xxxxxxxxxxx<mailto:wjwagman@xxxxxxxxxxx>> 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)
--------------------------------------------------------------------------------
Typ=1 Len=12:01,02,03,04,05,06,07,08,09,10,11,12
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
Other related posts:
