In Oracle11 g ORDER BY clause is used to sort data andit is also used in mysql ,ms access.Though we not to mention ASC to sort in increasing order because by default it sorts the data in ascending order if we do not mention ASC or DESC.To sort in descending order we have to mention DESC.
Explanation: In Oracle11 g , there are certain ORDER BY clause which instruct the result to appear in the particular order. Some ORDER BY clause are for ascending order, descending order , selection of row or column etc.
The ascending order can be done using the command of ASC in ORDER BY clause and ASC will be considered as default if the order is briefly described.
