Re: Question re inserting hashed strings (I think)

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 24 Apr 2009 18:16:46 -0700
Message-ID: <bf46380904241816g5a971487s8236f778bac539a4_at_mail.gmail.com>

On Fri, Apr 24, 2009 at 4:00 PM, William Wagman <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)
>
> --------------------------------------------------------------------------------
> 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

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

Received on Fri Apr 24 2009 - 20:16:46 CDT