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

Which name space is used to get assembly details?

704

What is the full form of ado.net?

746

Do we use stored procedure in ADO.Net?

742

Explain the two fundamental objects in ado.net?

677

What is data relation in ado.net?

715

What is ado code?

704

Describe datareader object of ado.net with example.

696

What are the data access namespaces in .NET?

884

Is datareader faster than datatable?

711

how Sequence to connect and retrieve data from database using dataset?

945

Why edit is not possible in repeater?

699

What is disconnected scenario in entity framework?

766

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

779

How to add an aggregate column?

747

What is ole in vb?

680