AW: Error in Rownum Select

In this statement, I'm trying to get (last working day - 6 days) from a specific table. If I remove the ORDER BY, I can never retrieve the correct rownum and of course the date.

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 17:42 -----

Stefan Jahnke <Stefan.Jahnke_at_bov.de>
bov.de
Sent by: root_at_fatcity.com
11.02.2003 17:23
Please respond to ORACLE-L

To:
Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject:
AW: Error in Rownum Select  

Hi  

Maybe I miss the point, but I don't really see the need for an order by here ? Can't you just dismiss it ?  

Regards,
Stefan  

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: stefan.jahnke_at_nospam.bov.de
Please remove nospam to contact me via email. visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:andrea.palluck_at_bov.de. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above.
-----Ursprüngliche Nachricht-----
Von: emre.hancioglu_at_eu.effem.com [mailto:emre.hancioglu_at_eu.effem.com] Gesendet: Dienstag, 11. Februar 2003 16:34 An: Multiple recipients of list ORACLE-L Betreff: 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).