select * from tableName where rowid = (select max(rowid) from tableName);

How to fetch the last inserted record in a particular table?

Question Posted / sudhakar sakthivel

Answer Posted / sudhakar sakthivel

select * from tableName where rowid = (select max(rowid)
from tableName);

in oracle

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different methods by which we can populate a dataset?

1227

What are the Data providers in ADO.Net?

1011

Explain the difference between sqlcommand object and command behavior object?

1077

Explain the advantages and disadvantages of using datalist?

1069

What is row state?

969

What is difference between datatable and dataset?

1052

Define isolation?

953

Explain the difference between data reader and data adapter?

962

What is the difference between the clone() and copy() methods of the dataset class?

1079

Explain the architecture of ado.net?

1056

How do you update a dataset in ado.net?

1016

How do you merge 2 datasets into the third dataset in a simple manner?

988

What are the features of ado.net?

1026

What are the essential features of ado.net?

947

Which is the best method to get two values from the database?

962