Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Problem ?
From your example, everything about T1 is already in T2. You don't need T1 to do the update.
update T2
set sequence = c1+c2+c3 (or whatever)
"Tahar Bellem" <mohamedtahar.bellem_at_ctrceal.caisse-epargne.fr> wrote in
message news:8qfa2h$jbm$1_at_pollux.ip-plus.net...
> Hi all,
>
> I want to increment a column ' Sequence' in a destination table 'T2' by
> using values of other columns
> (t1.c1, t1.c2, t1.c3) of a table 'T1'.
>
> exemple:
>
> Table :T1
>
> C1 C2 C3 C4
> ------------------------------------
> 1 1 1 A
> 1 1 1 A1
> 1 2 1 AA
> 1 1 2 B
> 1 1 2 C
> 1 1 2 CC
> 2 3 6 XX
>
> Table Destination : T2
>
> C1 C2 C3 C4 Seqence
> ----------------------------------------------------
> 1 1 1 A 1
> 1 1 1 A1 2
> 1 2 1 AA 1
> 1 1 2 B 1
> 1 1 2 C 2
> 1 1 2 CC 3
> 2 3 6 XX 1
>
> Someone can help me ?
>
> Thanks
>
>
>
>
>
>
>
Received on Sat Sep 23 2000 - 17:34:18 CDT