Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: rownum

Re: rownum

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 18 Aug 1999 18:38:43 GMT
Message-ID: <37c9fd6b.200422602@newshost.us.oracle.com>


A copy of this was sent to "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> (if that email address didn't require changing) On Wed, 18 Aug 1999 19:53:37 +0200, you wrote:

>This feature, the inline view, was introduced in Oracle 7.2. You should be
>able to use it in 8.0.5 without problem.
>

ahh, but the ability to ORDER by in the inline view was added in 8.1.....

btw: inline views came out with 7.1, first documented in 7.2...

>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>Norris <johnnie_at_cooper.com.hk> wrote in message
>news:7pdjup$299s$1_at_adenine.netfront.net...

[snip]

>>
>> > in 8i you can perform things like
>>
>> > select * from
>> > ( select blah
>> > from table
>> > order by 1,2,3)
>>
>> > which would allow the use of rownum like you are after, but if you are
>> > using some sort of reporting tool, you'd probably be better off using a
>> > built-in facility of the tool to number your records...

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 18 1999 - 13:38:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US