What is the standard execution sequence of an SQL Statement followed by Oracle Database engine?

Oracle Apps Interview QuestionsCategory: SQLWhat is the standard execution sequence of an SQL Statement followed by Oracle Database engine?
Questions Master asked 2 years ago
1 Answers
Shailender Thallam Staff answered 2 years ago

When a query is submitted to the database, it is executed in the following order:
FROM clause
WHERE clause
GROUP BY clause
HAVING clause
SELECT clause
ORDER BY clause