Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: move a row from table t1 to t2
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