to fetch ist 25 rows

[ankurnakai]

i want to fetch ist 25 rows from a tables depending on the last updated time

[r035198x]

i want to fetch ist 25 rows from a tables depending on the last updated time

I'm not sure about the depending on last updated time part, but to select thefirst n values you can use a cursor and a record:

[CODE=sql] begin
open myCursor_cur;
loop
fetch myCursor_cur into myRec_rec;
exit when myCursor_cur%ro wcount = 25;
......
[/CODE]

[debasisdas]

There is nothing like last updated time in oracle.

If u want to store that ,u have to store in a separate field.

then u can use any logic to retrive those records.