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: ORA-03113: End of file on communication channel
Next Topic: Updation in a table
Goto Forum:
  


Current Time: Sat Aug 19 17:39:55 CDT 2017

Total time taken to generate the page: 0.18346 seconds