Compound Triggers in Oracle 11g – Tutorial with example
In depth tutorial on Compound Triggers in Oracle 11g with examples. Also we see an example of using Compound Triggers in Auditing of some data.
oracle-11g Tutorials, Tips & Tricks
How to pass CLOB argument in EXECUTE IMMEDIATE
Since Oracle 11g it is possible to pass CLOB argument in EXECUTE IMMEDIATE statements. This allows to overcome default 32k size limit of passing parameters.
Oracle XMLTable Tutorial with Example
Oracle XMLTable: Learn how to parse XML in Oracle using XMLTable in 11g. Use XPath to query XML nodes in Oracle.
Oracle Skip Locked
Oracle 11g introduced SKIP LOCKED clause to query the records from the table which are not locked in any other active session of the database. This looks quite similar to exclusive mode of locking. The select for...
Index Skip Scan in Oracle
With Oracle 9i, the Cost-Based Optimizer (CBO) is equipped with many useful features, one of them is “Index skip scan“. In previous releases a composite index could only be used if the first column,...
Pagination in Oracle using ROWNUM and Limiting Result Set
ROWNUM is a magic column in Oracle Database that gets many people into trouble. When you learn what it is and how it works, however, it can be very useful. I use it for...
Index usage with LIKE operator in Oracle & Domain Indexes
A lot of developers might be confused about index selectivity while using %LIKE% operator. So please find below how index worked when you use LIKE operator. Problem Statement While optimizing high CPU consuming queries on 3rd...
Oracle 11G new feature: Virtual Column
Oracle 11g introduced the concept of ‘Virtual Column’ within a table. Virtual Columns are similar to normal table’s columns but with the following differences: They are defined by an expression. The result of evaluation...