"tIM" <tjm_at_geac.dk> wrote in message
news:b1f8412c.0110252329.1668a366_at_posting.google.com...
> The point is why does INSERT INTO ... SELECT ... ORDER BY
> work when run stand alone but does not compile when placed in a procedure.
Probably because PL/SQL lags behind sql by a bit.
<SNIP>
> The other post probably hints to my answer that I needn't care about
> about the order by which is what I did.
This is a basic feature of an RDBMS. You shouldnever need to know where and
how records are stored. if you wish to deal with records in a specific order
you only need to select them out in that order.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
Received on Fri Oct 26 2001 - 06:47:30 CDT
