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 -> move a row from table t1 to t2

move a row from table t1 to t2

From: Prasath <prasath.rao_at_gmail.com>
Date: 1 Feb 2007 07:26:00 -0800
Message-ID: <1170343560.742415.202130@a34g2000cwb.googlegroups.com> 





Hi,



I have a requirement, where I frequently move a row from table t1 to
t2.   The tables have an identical structure.



I accomplish this task in two steps.



    
  
  1.   INSERT into t2.
  
  2.   DELETE from t1.






Is there an efficient way of doing this? Can this be accomplished in
one step?



Thanks,


Prasath.
Received on Thu Feb 01 2007 - 09:26:00 CST












Original text of this message













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