Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rownum
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
![]() |
![]() |