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 providers does Ado.net uses?

1064

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086

What is the role of data provider in ado.net?

1045

How to bind the controls(best practice) comboboxes to the data in the dataset?

1095

What is the difference between SqlCommand and SqlCommandBuilder?

1139

What is the difference between data reader and data adapter?

1073

What is openquery?

1034

How to connect and retrieve data from database using dataset

1102

Define data adapter?

1021

What are the 3 major types of connection objects in ado.net?

1052

What is openrowset?

1035

Which object is used to add relationship between two Datatables?

1094

Explain how to call the sql commands asynchronously in ado.net version 2.0?

979

Explain the differences between oledb sql server, oledbdotnet provider?

1054

What are the advantages and drawbacks of using ado.net?

1152