Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning results in the order they were entered

Re: Returning results in the order they were entered

From: Boffo Jinko <test_at_yahoo.com>
Date: Fri, 7 Nov 2003 10:29:27 -0500
Message-ID: <bogdop$1drj0g$1@ID-147295.news.uni-berlin.de>


That makes sense the way you described it, and it should work out well for me.

Thanks for the help guys!
Scott

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0311070545.304b188e_at_posting.google.com... > "mcstock" <mcstockspamplug_at_spamdamenquery.com> wrote in message news:<2eqdnUt3Xt5yTTeiRVn-iQ_at_comcast.com>...
> > you're going to have to record the date entered and then sort on that
> >
> > reason -- oracle can and will reorder the physical location of the rows
> > (during normal operation and typical maintenance operations), so if you
> > don't store a timestamp, so the order entered is not preserved
> >
> > --
> > Mark C. Stock
> > email mcstock -> enquery(dot)com
> > www.enquery.com
> > (888) 512-2048
> >
> >
> > "Boffo Jinko" <test_at_yahoo.com> wrote in message
> > news:boehfl$1e08bm$1_at_ID-147295.news.uni-berlin.de...
> > > I have a query that returns the results of a basic select statement,
like
> > > so:
> > >
> > > select distinct id,name from Caseflow.cases where number1 in
> > > (124125,124122,124130);
> > >
> > > When this query is returned, it returns the results in order from
lowest
> > to
> > > highest. This is typically okay, but I need to have the results
returned
> > in
> > > the order they were entered by the user. So in the above example, the
> > > results would have to be returned at 124125,124122,124130, not
> > > 124122,124125,124130 as they normally would be. Is there a way to do
this,
> > > or am I going to have to resolve this problem in my web page code?
There
> > are
> > > no other fields in common that I could sort by - it has to be by the
> > number
> > > entered in the IN clause, and they are often not in any kind of order.
And
> > > no, telling the user to enter them differently isn't an option!
> > >
> > > Thank you,
> > > Scott
> > >

>
> Scott, to add to what Mark said, according to relational theory
> definition a table is an unordered heap of data so the only way to
> guarantee the order of data in Oracle is to order it using the ORDER
> BY clause.  In your case since you want physically inserted time order
> you either need a timestamp or a sequence number that the query can
> order on.
>
> HTH -- Mark D Powell --
Received on Fri Nov 07 2003 - 09:29:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US