We are planning to do column level encryption on oracle 9i database. i need to know the steps to do column level encryption for existing data as well as new data. the column which we want to encrypted is a primary key in few tables and there are indexes on few tables. so i need to know how to handle these situations.

thanks in advance.