Oracle Tutorials, Tips & Tricks

Auditing DML changes in Oracle

Auditing DML changes in Oracle

We are often faced with a situation when every DML change (Inserts/Updates/Deletes) made in Oracle/SQL tables must be audited. Banking Softwares and other similar applications have a strict requirement to maintain the audit trail...

45 Useful Oracle Queries

45 Useful Oracle Queries

Here’s a list of 40+ Useful Oracle queries that every Oracle developer must bookmark. These queries range from date manipulation, getting server info, get execution status, calculate database size etc. Date / Time related...

Oracle Skip Locked

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

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,...