oracle view

[chita12342003]

hello everbody,
can anybody tell me that why we cannot use order by clause in view.

[Chandrasekar.m]

I assume you are talking about creating view.

We can Use Order by Clause while creating View. I am not sure about the version that you are working on. It works in 10g

CREATE VIEW employeeview AS SELECT *FROM employees ORDER BY 1 DESC;

So if we execute
SELECT *FROM employeeview ;

It would return employee records on descending order of first column.

Hope this clarifies.