REVERSE FETCH

It is possible to perform a reverse fetch in DBMS by using a SQL ORDER BY statement using the DESC keyword. This feature takes advantage of the natural indexes in DBMS.

 

Example:

SELECT * FROM dbms_table
ORDER BY cnx_dbms_table desc