Insert from another table...
From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/01/17
Message-ID: <5bp2pv$n4l_at_nntp1.u.washington.edu>#1/1
Date: 1997/01/17
Message-ID: <5bp2pv$n4l_at_nntp1.u.washington.edu>#1/1
[Quoted] [Quoted] 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 Fri Jan 17 1997 - 00:00:00 CET