Home » SQL & PL/SQL » SQL & PL/SQL » retrieve last row inserted
retrieve last row inserted [message #202680] Fri, 10 November 2006 23:09 Go to next message
dejiesdeoder
Messages: 4
Registered: November 2006
Junior Member
Hi,
Can anyone tell me how to retrieve last row inserted into the table if that table doesnot have columns like creation_date,Last_update_date...

I tried to retrieve using rownum but it didn't work.


Any help will be greatly appreciated.


Thanks in Advance.
Dejies Deodar
Re: retrieve last row inserted [message #202692 is a reply to message #202680] Sat, 11 November 2006 00:41 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
That can't be done. If there is no column indicating the order of inserts, there is no way to know (from the table) the order in which the rows were inserted.
Re: retrieve last row inserted [message #202719 is a reply to message #202692] Sat, 11 November 2006 05:02 Go to previous message
dejiesdeoder
Messages: 4
Registered: November 2006
Junior Member
Thanks Frank for your reply
regards
Dejis
Previous Topic: Display 2 constant values as rows using one select statement!!
Next Topic: ORA-04091: table XXXX is mutating, trigger/function may not see it
Goto Forum:
  


Current Time: Tue Dec 06 00:20:47 CST 2016

Total time taken to generate the page: 0.06502 seconds