Re: data row

"David" <dacon_at_medinet-igd.com> wrote in message news:<c7nqog$ic5$1_at_nsnmpen3-gest.nuria.telefonica-data.net>...
> Hello,
>
> Knows anybody how i can move data from a row to another row in the same
> table?
>
> row A Data
> 1
> 2
> 3
> ....
>
> Move to row B (empy)
>
> I think that I can rename the rows, how i can do it?
>
> I'm using Oracle 8.1.7
>
> Thanks in advance.
>
> David

This is the sql that will copy rowA to rowB. You can add where clause also.

Update tableX set rowB = RowA;

Curtis Received on Wed May 12 2004 - 19:00:29 CEST