What is the purpose of the ORDER BY clause in SQL?
How do you use the ORDER BY clause to sort data in ascending order in Oracle?
How do you sort data in descending order using the ORDER BY clause?
Can you sort data by multiple columns using the ORDER BY clause in Oracle? How?
How do you use column aliases in the ORDER BY clause?
How do you sort data using an expression in the ORDER BY clause?
How do you handle NULL values when sorting data using the ORDER BY clause in Oracle?
How can you sort data by a calculated column in the ORDER BY clause?
How do you sort data by the position of columns in the SELECT statement using the ORDER BY clause?
Explain a scenario where you need to use the ORDER BY clause in a subquery and how you would implement it in Oracle.