Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ORDER BY in View's subquery
The student guide for Introduction to Oracle9i: SQL mentioned that "the
subquery that defines the view cannot contain an ORDER BY clause" (chap
11-8). But I tested this with 9iR2 and the ORDER BY is allowed?! Is this
just a difference between 9iR1 and 9iR2? Or is there something I am missing
and a view's query really cannot have an ORDER BY ?
Thx for any advice Received on Tue Jan 18 2005 - 23:04:29 CST
![]() |
![]() |