ORDER BY

Order By - keyword tutorial

This is the order in which Oracle orders the values when ORDER BY is used

Ascending Order:

1
2
A
B
a
b

This is the order in which Oracle orders the values when DESC keyword is used along with ORDER BY

Descending Order:

b
a
B
A
2
1