Re: uncrypting a field

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 20 Feb 2003 23:45:46 GMT
Message-ID: <MPG.18bf088087eee0539896c0@news.la.sbcglobal.net>

jeanvincent.thfei_at_vnumail.com said...
> Hi,
>
> How to uncrypt a field taht contains patterns like
> password.
> I would like to do using a Select statement or any
> tools of 7 or 8 Oracle version.
>
> Thanks.
>

The problem is that fields containing patterns like password will not decrypt to a single value. To decrypt other fields you need to know the public/private key used to encrypt it.

-- 
/Karsten
DBA > retired > DBA

Received on Thu Feb 20 2003 - 17:45:46 CST