Oracle toolkit for Encryption Decryption: dbms_obfucation
You can use the toolkit dbms_obfucation that comes with Oracle. It works like a charm.
You can use insert trigger to encrypt data and select trigger to decrypt data.
You can make use of synonyms, views and a new schema to restrict decryption to only certain users.