Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 CST