Re: Gurus -- why restriction on sequence?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 12 Aug 1999 16:42:54 +0100
Message-ID: <934484632.11241.0.nnrp-04.9e984b29@news.demon.co.uk>

No, but I tried it on 8.0.4, and then tried the following workaround:

select *
from
( select xxx.nextval, object_name from user_objects) order by

object_name;

and got ORA-03113 !

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Martin Douglas wrote in message <37B2DC49.4570C1F9_at_Boeing.com>...
>'lo,
>
>Why can a sequence not be used in the select expression of a SELECT
>statement when an ordered by clause is present???
Received on Thu Aug 12 1999 - 10:42:54 CDT