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 the difference between the clone() and copy() methods of the dataset class?

540

How can we add/remove row's in "datatable" object of "dataset"?

537

What is datasource in ado.net?

579

What is bubbled event can you please explain?

520

What are the disadvantages of using datalist?

501

Explain how can we load multiple tables in to dataset?

494

What are the data access namespaces in .NET?

625

What are the ado.net objects?

510

What are the Features of a dataset

663

How do you update database through dataset?

533

What is typed dataset ?

671

What are the steps to connect to a database?

543

how we can fire event in databound coulm in datagfrid withot using button?

567

What are the data providers used in ado.net

539

What is the current version of entity framework?

475