Re: sort without order by

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 17 Nov 1999 08:31:09 -0500
Message-ID: <460yOJef1dyg75sckSORZy62zl0e@4ax.com>

A copy of this was sent to Norris <jcheong_at_cooper.com.hk> (if that email address didn't require changing) On 17 Nov 1999 05:34:20 GMT, you wrote:

>In SQLServer, I can select data from table without order-by and the records are sorted according to the clustered index of the table. What is the syntax in oracle?

you would use an index organized table. A full scan of an index organized table returns the data in the order of the primary key. These are available in Oracle8.0 and up.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Nov 17 1999 - 07:31:09 CST