RE: Error in Rownum Select

It seems so..

Thanks.

Regards

M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-2576
Fax: +49 2162 41497
E-Mail: emre.hancioglu_at_eu.effem.com
----- Forwarded by Emre M. Hancioglu/VSN/Effem on 11.02.2003 16:10 -----

"Stephane Faroult" <sfaroult_at_oriolecorp.com> oriolecorp.com
11.02.2003 15:32
Please respond to "Stephane Faroult"

To:
emre.hancioglu_at_eu.effem.com
cc:

Subject:
RE: Error in Rownum Select  

Not absolutely certain of it but I think that allowing 'order by' in views (regular or in-line) is a feature which was introduced with 8.1.6. No easy workaround ...

>----- ------- Original Message ------- -----
>From: emre.hancioglu_at_eu.effem.com
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Tue, 11 Feb 2003 05:39:13
>
>Hello,
>Can anyone tell me the reason, why I get an error
>because of the "Order
>By" in Oracle 8.1.5.
>It works fine in 8.1.7 and 9.2.
>
>declare
> v_t number(8);
>begin
> SELECT tagesdatum into v_t
> FROM (SELECT rownum n, tagesdatum
> FROM (SELECT tagesdatum
> FROM kalender
> WHERE tagesdatum <=
>to_number(to_char(sysdate,'yyyymmdd'))
> AND tag_type = 'A'
> ORDER BY tagesdatum
DESC
> )
> )
> WHERE n=6;
>end;
>
>
>
>Regards
>
>M.Emre HANCIOGLU
>Masterfoods Services GmbH
>ISI Application Support
>Tel : +49 2162 500-2576
>Fax: +49 2162 41497
>E-Mail: emre.hancioglu_at_eu.effem.com

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: emre.hancioglu_at_eu.effem.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).