Re: ROWNUM - Questions

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 19 Dec 2000 11:51:34 -0000
Message-ID: <91ni47$4r0$1@soap.pipex.net>

rowid?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message
news:91ltqn$j23$05$1_at_news.t-online.com...


> ROWNUM is nice, but for my appl. the pity is that ROWNUM is independet to

 a


> ORDER by. That mean

>

> select rownum,columnname from tablename

> and

> select rownum,columnname from tablename order by columnname

>

> brings not the rownumbering I am looking for.

>

> I need a rownumbering which is independent from the ordering.

>

> Any suggestions?

>

> Thanks

>

> Nicolas

>

>

Received on Tue Dec 19 2000 - 05:51:34 CST