Re: internal order of oracle tables

From: Hans Forbrich <forbrich_at_tibalt.supernet.ab.ca>
Date: 11 Jul 1994 22:08:01 -0600
Message-ID: <2vt4v1$nts_at_tibalt.supernet.ab.ca>


Robert J. McCallister (rjmac_at_crl.com) wrote:
> Sure there is a way to have all the records in a table sorted by the primary
> key, it is not very easy but try this:
 

> Print out all your records, get a bunch of file folders, label each
> folder with the primary key, place the record in each folder, place the
> folders in the file cabinet in order by the primary key. That is pretty
> simple right? Does what you want right? Takes to much time right?
 

> Alternative:
 

> Let Oracle do the work for you, what difference does it make what order
> the records are in the table, to get them out in the proper order all you
> have to use is an order by clause in the select statement, if you want


^^^^^^^^^^^^^^^^^^^^^^^

By definition of SQL and 'relational'
model, you must always supply an order by clause - the model guarantees that there is no guarantee to the order internally stored.<g>

/Hans Received on Tue Jul 12 1994 - 06:08:01 CEST

Original text of this message