Question

How can we view last record added to a table in Oracle?

Answer 1

Last record can be added to a table and this can be done by –

Select * from (select * from employees order by rownum desc) where rownum<2;