Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert from another table...
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 xReceived on Fri Jan 17 1997 - 00:00:00 CST