|
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.
|