How To Identify Time Of Last Row Update

Identifying the time a row was last updated used to involve either adding a column to the table itself and coding the application to update it with a date and time value, or switching on auditing with its performance overheads, or using Logminer to trawl through old archive logs.

TAGS : Girish, Shine

 

Read More
Comment

SQL Tuning Hierarchy - Visual

A picture is worth a thousand words.
— Napolean Bonaparte
Comment

Oracle - Creating an external table

The external tables feature is a complement to existing SQL*Loader functionality. It enables you to access data in external sources as if it were in a table in the database. Prior to Oracle Database 10g, external tables were read-only. However, as of Oracle Database 10g, external tables can also be written to

Read More
Comment

ANSI Joins

A natural join, as its name implies, can be invoked when two or more tables share exactly the same columns needed for a successful equijoin

Read More
Comment