RE: Question re inserting hashed strings (I think)

From: William Wagman <>
Date: Mon, 27 Apr 2009 12:40:03 -0700
Message-ID: <>


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

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208
From: Jared Still [] 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 <<>> 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;


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

Received on Mon Apr 27 2009 - 14:40:03 CDT

Original text of this message