Re: insert statement using order by
From: <rtproffitt_at_my-deja.com>
Date: 1999/10/11
Message-ID: <7ttjgk$fin$1_at_nnrp1.deja.com>#1/1
Date: 1999/10/11
Message-ID: <7ttjgk$fin$1_at_nnrp1.deja.com>#1/1
In relational theory, you never know nor can depend on what order your data is stored in, so inserting into a table with an order by clause doesn't make sense...
You would use Order by in your views or
select statements to guarantee the order
of your data...
In fact, I have seen Oracle insert my
individual insert statements into a
different order than I had inserted them, so
one cannot trust the physical storage
to order the data.....
Robert Proffitt
Beckman Coulter
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 11 1999 - 00:00:00 CEST