automated email notifications will go to a particular email. I'd like to read the inbox, process the email, and then delete it. these are small emails--less than 2k. What is the easiest way to do this from pl/sql?
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…