Oracle documentation specifies that the query that defines a view cannot contain the ORDER BY or FOR UPDATE clauses.
But according to the book oracle DBA certification exam guide(by JASON S.COUCHMAN) the query that defines a view can contain the ORDER BY clause.
Can anyone help me in clarifying, whether we could use order by clause in defining a view or not