Hi hrishy

My requirements are to take information in an existing table, populated with data, and run a procedure to encrypt one of the columns.

Also for all future inserts into that column to be encrypted.

For example.

create table test( name varchar2(30), password varchar2(40));

Populate it;

select * from test;
test password
---- ------------
alison oracle
andrew obvious
caroline chocolate

I would now like to encrypt the entire password column.

I understand that this is a very simple example but any sample code would be appreciated.

Many thanks

Alison

sambavan - thanks for the links they have helped me understand the theory behind the procedure