If you are a table owner, you can use alter table with the decrypt option to drop encryption on a column.
For example, to drop encryption on the creditcard column in the customer table, enter:
alter table customer modify creditcard decrypt
If the creditcard column was encrypted by a key with an explicit user password, you would need to set that password first.
