Oracle-L: Error in Rownum Select

From: <emre.hancioglu_at_eu.effem.com>
Date: Tue, 11 Feb 2003 05:39:13 -0800
Message-ID: <F001.005491EB.20030211053913@fatcity.com>

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
--

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). Received on Tue Feb 11 2003 - 07:39:13 CST