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

Some important instruction regarding ADO.NET connection string ?

936

What is the provider being used to access oracle database?

947

What are the important features of ado.net 2.0?

1027

What is a sqldataadapter?

955

Explain the architecture of ado.net?

1020

What is a data control clerk?

994

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

980

What are datareaders?

929

Describe ado.net object model in detail.

952

What is difference between executequery and executeupdate?

931

Is it possible to edit data in Repeater control?

902

What is ole db and odbc?

868

What is connection in ado.net?

897

What is the difference between sqldatareader and sqldataadapter?

928

Which architecture does Datasets follow?

994