Encryption should be transparent to any application.
If you use Oracle Database Enterprise Edition, you could go with one of its options to achieve that. AFAIK Advanced Security might be what you need - see Options and Packs
Can we apply this Advance Security options on selective product schemas/ tables? Is this approach followed or suggested when security is required.