Re: How to display items in the order that they were input in ORACLE 8?

The only way to guarantee a retrieval sequence is to have a sortable field. In Oracle, this would mean a sequence number field that is either part of the key or 'extra' in the row. The only other way is to have the entire table/object fit within 1 db read (usually 5 blocks/10K) and never be changed.

Say hello to Sam Perez and John Serrano for me (Joe M. at NPC).

In article <AAB3rArCT6_at_unisoft.dp.ua>,   oracle_at_unisoft.dp.ua wrote:
>
> order by ROWNUM ?..
> Oracle says: 'ROWNUM - position of single row among other rows selected
> by query...'
>
> IMHO, 'order by ROWNUM' equal no order at all.
> Better way to use new column with values from sequence
> and trigger 'after insert' for table.
>
> BR,
> Eugene
>
> 2-Apr-98 15:35 Hero R. Post wrote:
> :>You can try ordering the records by Rownum
> :>Select <column1>,<column2>.....
> :>from <tablename>
> :>order by ROWNUM
> :>
> :>Hope it works (it does with me)
> :>Hero
> :>
> :>m.L. wrote in message <35237a8f.150133733_at_news.earthlink.net>...
> :>>
> :>>Hi everyone,
> :>>
> :>> I have a question from work. We are trying to display the
> :>>order of the details (master-details) in the order that they were
> :>>input. Oracle always sort out its display by certain column, and we
> :>>are trying to accomplish the inputorder withing adding extra column.
> :>>
> :>>any helps will be greatly appreciated.
> :>>
> :>>
> :>>Michael L.
> :>
> :>
> :>
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 09 1998 - 00:00:00 CEST