What do you mean by "last record"? The one with highest index value? If so, you can use mytable.LAST.

If you mean sorted by some PL/SQL table's field then no, there is no such magical way. You have to read all the records and find the highest value in that field programaticaly.