Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insert from another table...

Insert from another table...

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/01/17
Message-ID: <5bp2pv$n4l@nntp1.u.washington.edu>#1/1

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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US