Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail
From: wtistang@hotmail.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to Use Cursor variable in Where Statement
Date: 11 Nov 2005 06:10:31 -0800
Organization: http://groups.google.com
Lines: 10
Message-ID: <1131718231.346267.313830@g47g2000cwa.googlegroups.com>
References: <1131716031.431225.114570@g14g2000cwa.googlegroups.com>
   <4374a44e$0$549$626a14ce@news.free.fr>
NNTP-Posting-Host: 67.191.172.56
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1131718236 10333 127.0.0.1 (11 Nov 2005 14:10:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 11 Nov 2005 14:10:36 +0000 (UTC)
In-Reply-To: <4374a44e$0$549$626a14ce@news.free.fr>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g47g2000cwa.googlegroups.com; posting-host=67.191.172.56;
   posting-account=9OGgNg0AAABJbRZfilERQj0OX_wGTnVt
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:123266

Thanks for your response.

The key is right.  What I try to do here is to get data from one table
and use the key field and value field to update the second table where
is key matches. Do you have example how to do it in BULK operation?

Thank you.

Mike