Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORDER BY in View's subquery

ORDER BY in View's subquery

From: <tncc>
Date: Wed, 19 Jan 2005 13:04:29 +0800
Message-ID: <41edea5d$1_2@rain.i-cable.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US