Re: SQL Question : From MS SQL Server to Oracle

From: Erwin jasinski <hexalog_at_wanadoo.fr>
Date: Sat, 26 Jun 1999 21:58:40 +0200
Message-ID: <7l3bkc$f9r$1@wanadoo.fr>

You are right !

I look for your PL/SQL procedure.
Thank you very much

Erwin

Ed Prochak a écrit dans le message <7l0dkq$9rr$1_at_nnrp1.deja.com>...
>Warning! Andrew's query does not do what you want.
> (Test it. You'll see.)
>
>ROWNUM is a pseudocolumn and the values are assigned BEFORE any sorting
>takes place. So you effectly get 10 randomly selected entries from the
>table which are then ordered by Col1.
>
>Basically to do the exact same thing as SQL Server, you will need to
>write a PL/SQL procedure. Search this groups for previous discussions
>on this topic. Code has been posted before. (I may have a copy
>somewhere.)
>
>Good luck.
>
>
>
Received on Sat Jun 26 1999 - 14:58:40 CDT