Re: encrypting a column

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/07/20
Message-ID: <8l5toh$elm$1@perki.connect.com.au>#1/1

in oracle 8.1.6 there is a package which encrypts data it uses des method. if you are not running 8.1.6 then you need to use external procedure to call a C function to encrypt the data, you could create a trigger and in the trigger call your external function to encrypt the data. before or after.(before is better).
Tom

Bhavin Shah <bhavinsh_at_aludra.usc.edu> wrote in message news:Pine.GSO.4.21.0007191838570.7952-100000_at_aludra.usc.edu...
> Hi,
>
> Is there a way to encrypt a particular column during insertion?
> Otherwise how do you do it after an insert?
>
> Thanks.
>
Received on Thu Jul 20 2000 - 00:00:00 CDT