Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query to fetch latest record by SYSTEM

A R KhanAug 7 2014 — edited Aug 7 2014

I have a requirement where I need to fetch the latest record persisted by 'SYSTEM' even it has been modified by multiple users. Request you to help me in building that query.

Case-1 data:
uniqueId-111 --> This record has been inserted by user-SYSTEM twice(records-1,4) and the same has been updated by multiple users(records-2,3,5). Now i need a query when i pass Id=111 and Type=I i should get the latest record inserted by 'SYSTEM' i.e record-4

Case-2 data:
uniqueId-222 --> This record has been inserted by user-SYSTEM once(records-6) and the same has been updated by multiple users(records-7,9).When i pass Id=222 and Type=I i should get the latest record inserted by 'SYSTEM' i.e record-6

Enclosed the image of the test data that I have.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2014

Added on Aug 7 2014

#general-database-discussions

3 comments

191 views