Compound Trigger – A Performance Improvement for Trigger Executions

In Oracle database 11g release version 1, among the enhancements in trigger execution an important and efficient feature known as ‘Compound Trigger’ is rolled out. This feature is particularly exciting because of the performance improvements it may bring in along with it. Auditing Bulk INSERT/UPDATE of a Table Efficiently Assume you have a transactional table, this [...]

Virtual Columns in Oracle 11g R1

I just found out this good feature in Oracle 11g release 1. How many times you felt tired because you were coding again and again for a particular function while selecting data from table? Consider the following table. The table contains employee name, date of joining. Year of joining will not be stored in database [...]