Re: How to display items in the order that they were input in ORACLE 8?
From: Hero R. Post <HERO.POST_at_ORAP.NL>
Date: 1998/04/02
Message-ID: <6g04ft$rts1_at_reader3.wxs.nl>#1/1
Date: 1998/04/02
Message-ID: <6g04ft$rts1_at_reader3.wxs.nl>#1/1
You can try ordering the records by Rownum
[Quoted] 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.
Received on Thu Apr 02 1998 - 00:00:00 CEST