Which statement is true regarding the default behavior of the ORDER BY clause?
A.
In a character sort, the values are case- sensitive.
B.
NULL values are not considered at all by the sort operation.
C.
Only those columns that are specified in the SELECT list can be used in the ORDER BY clause.
D.
Numeric values are displayed from the maximum to the minimum value if they have decimal positions.
A. In a character sort, the values are case- sensitive.
Could someone provide a real example that shows “in a character sort, the values are case- sensitive”?
thanks
Here is example
http://stackoverflow.com/questions/9788838/how-can-i-sort-by-a-table-column-in-varying-cases-oracle
Please explain why is Option A correct? Thanks
Here is also quite detailed explanation about how Oracle sorts data.
http://www.orafaq.com/node/999