Re: Why Oracle View can not use Order by clause in the View definition query ?...

>create view dept_v as select * from dept order by deptno;
>
>And then you ran the query:
>
>select * from emp_v, dept_v where emp_v.empno = dept_v.deptno;
>
>What would happen to the order by's since they conflict with eachother?
>
All that you write makes perfect sense. But what would happen if you 'cheated' in the creation of the views and grouped by the primary keys?

-- 
Paul Brewer