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

Re: move a row from table t1 to t2

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 2 Feb 2007 09:42:59 -0800
Message-ID: <1170438179.821348.62880@m58g2000cwm.googlegroups.com>


On Feb 1, 10:26 am, "Prasath" <prasath...._at_gmail.com> wrote:
> 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.

What makes your approach inefficient? Takes too long? Resource utilization? Received on Fri Feb 02 2007 - 11:42:59 CST

Original text of this message

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