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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Query sorting without Order by

Re: Query sorting without Order by

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Mon, 5 Feb 2001 20:53:38 +0100
Message-ID: <95n099$4bb$04$1@news.t-online.com> 






> You can get the rows back in the order of the index like this :

>

> select /*+ INDEX (MY_TABLE_X, MY_TABLE) */ *

> from   MY_TABLE

>



From where do you have that? /*  and */ are reserved for remarks.



Regards


Nicolas
Received on Mon Feb 05 2001 - 13:53:38 CST












Original text of this message













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