In Oracle, ORDER BY DESC Clause is used to sort the result-set in descending order. To sort the result set, you must use the ORDER BY clause.
To sort the result set in descending order from existing table, use the following syntax:
tablename: The table name from which you want to remove all records.
DESC: To sort data set in DESCending order.
DESC: To sorts data set in descending order.
In the above example, we have fetched records from "tblCustomerLoan" table with specifying DESC in order by clause.