Re: Insert from another table...

The simple answer is that an 'order by' clause on an insert statement is a bit silly. Order of storage is completely irrelevant to a relational database. We all know, of course, that there is a physical order and that it is possible to play tricks with a known order. Nonetheless, it would be inappropriate for Oracle to support such syntax. It is simply outside the bounds of relational databases.

Roger

L. Tseng <lesliet_at_u.washington.edu> wrote in article <5bp2pv$n4l_at_nntp1.u.washington.edu>...
>
> Orcale does not take ORDER BY clause in the following insert
> syntax. Do you know why? Any suggestion on workaround?
> Thanks,
> Leslie
>
> insert into table_a (col1, col2,col3)
> select x, y, z from table_b
> order by x
>
>
  Received on Mon Jan 20 1997 - 00:00:00 CET