FIND LAST UPDATED RECORD DETAILS

FIND LAST UPDATED RECORD DETAILS

select * from dept where rowid in (
SELECT rowid
FROM <TABLE_NAME>
MINUS
SELECT rowid
FROM <TABLE_NAME>
AS OF TIMESTAMP TO_TIMESTAMP('2014-07-14', 'YYYY-MM-DD'));