Re: ORDER BY record sequence

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Fri, 6 Nov 98 08:13:30 +0200
Message-ID: <AMAEfGsK42@protasov.kiev.ua>

Hi,

You should create numeric field, fill it from the sequence and use order by. Or create date field and fill it from sysdate.

Andrew Protasov

> hi all,
>
> I am stumped with this thing. I have a table where I enter say 10 records. I
> then need retrieve the records IN THE ORDER THEY WERE ENTERED. I tried ORDER
> BY ROWID but that didn't work.
>
> Anyone got any clues? It seems elementary doesn't it?!
>
> Thanks in advance,
> Vijay
>
> -----------------
> "A truly happy person doesn't expect much from life" - who else but me!
> -----------------
> Vijay G Hariharan
> vharih1_at_umbc.edu
>
>
>
Received on Fri Nov 06 1998 - 00:13:30 CST