Re: LIMITing output

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 22 Feb 2000 16:28:43 GMT
Message-ID: <38bbb299.7805323@netnews.worldnet.att.net>

On Mon, 21 Feb 2000 16:59:27 +0000, kev <kevin.porter_at_fast.no> wrote:

>Does 8i indeed support ORDER BY clauses in subqueries?

Yes. For example:

SVRMGR> select * from
     2> (select * from dual order by dummy)
     3> where rownum=1;

D
-
X
1 row selected.
SVRMGR> (btw, dummy is a column in the standard dual table. I'm not trying to offend here. It was just the easiest table to use to demonstrate this).

Check your database initialization file for a parameter named compatible. I think the default is not to enable the new 8i features. Be sure it reads like this:

        compatible=8.1.5

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Tue Feb 22 2000 - 10:28:43 CST