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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy a record from 1-table to another

Re: Copy a record from 1-table to another

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Dec 2005 22:33:40 +0100
Message-ID: <oq31q19itvgf5kdn5jf7j8tvtf7q9ba34h@4ax.com> 





On 14 Dec 2005 12:54:33 -0800, "JoeT" <trubisz_at_yahoo.com> wrote:



>Anyone have any suggestions?





insert into s(col1, col2, col3, col4 ....)
select col1, col2, col3, col4


from r



will work like a charm, and moreover: it will be a lot faster compared
to your nonscalable solution.


--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Dec 14 2005 - 15:33:40 CST












Original text of this message













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