Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Problem ?

Re: SQL Problem ?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Sat, 23 Sep 2000 15:34:18 -0700
Message-ID: <8qjb3u$pi1$1@spiney.sierra.com>

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

Original text of this message

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