Re: move a row from table t1 to t2

Prasath 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.

I can't think of one.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org