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