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 is different between sqlcommand object and command behavior object?

982

What is ado in agriculture?

885

What is connection pooling and what is the maximum pool size in ado.net connection string?

897

Which method is used to sort the data in ADO.Net?

1914

Why is it important to close an ado.net application?

963

What two types of data providers does ADO.NET supply? What determines which one you should use?

940

Why do we need ado.net?

904

Which database is the ado.net sql connection object designed for?

995

What is fill method in ado.net?

920

Explain the various objects in dataset.

934

What is the full form of ado.net?

929

Why is stored procedure used in ado.net?

1026

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1023

What is ado or jdbc?

870

What does datareader object do?

938