Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!t-online.de!newsfeed.t-com.hr!news1.t-com.hr!not-for-mail
From: "T" <t@yahoo.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Update a table with another
Date: Mon, 10 Oct 2005 14:21:25 +0200
Organization: T-Com
Lines: 43
Message-ID: <didmci$2rl$1@ss405.t-com.hr>
References: <1128760560.99@user.newsoffice.de>
NNTP-Posting-Host: 195.29.164.166
X-Trace: ss405.t-com.hr 1128946898 2933 195.29.164.166 (10 Oct 2005 12:21:38 GMT)
X-Complaints-To: abuse@t-com.hr
NNTP-Posting-Date: Mon, 10 Oct 2005 12:21:38 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:122544

try to use cursor


"Andreas Mosmann" <keineemails@gmx.de> wrote in message 
news:1128760560.99@user.newsoffice.de...
> Hi NG,
>
> maybe it is too early in the morning ...
>
> I have 2 tables [1]
>
> TableA (1000 rows) : ColA, ColB, ColC
> TableB (100 rows): ColD, ColE, ColF
>
> and I want to update TableA for each rows, that TableA.ColA=TableB.ColD
> There should be 100 updates.
>
> It is easy to select these rows
>
> select
>  ColA,ColB,ColC,ColE,ColF
> from
>  TableA
> join
>  TableB
> on
>  TableA.ColA=TableB.ColD
>
> But in this moment I am unable to find a statement to update these rows in 
> TableA.
>
> Thanks in advance
> Andreas
>
> [1] the 100 rows of TableB contain the old values of TableA at the rows 
> specified by ColD/ColA (PK)
>
>
>
> -- 
> wenn email, dann AndreasMosmann <bei> web <punkt> de