Re: How to update multiple rows having WHERE clause?

From: Rui Chambel <REMOVE_THISrchambel_at_netscape.net>
Date: Tue, 14 Sep 1999 18:15:01 +0100
Message-ID: <937332935.346590@orodruin.esoterica.pt>

As I can understand you can do this:

Update someTable set someTable.col1 = otherTable.col1 from someTable, otherTable
where someTable.otherColumn = otherTable.otherColumn

You must have some field common to both tables that can be used in a join (the otherColumn) .

Hope it helps,
CH3
--

---

Rui Chambel
- Portugal -
Delphi, C++, VB, Java, SQL, I*net
e-mail: rchambel_at_netscape.net

---

Make your life simple:
Write your own programs!

---

<bkrishnaiyer_at_refco.com> wrote in message news:7rboeq$sj8$1_at_nnrp1.deja.com...
> Usually one can update single row using UPDATE command in oracle when
> using WHERE clause. I want to know if we can update multiple rows with
> where clause.
>
> Ex: I want to set cololumn1 values of table1 with column1 values of
> table2.
>
> Can somebody please tell me how to do this ?
>
> Thanks,
> Bhagavan.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Sep 14 1999 - 12:15:01 CDT