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: Update multiple records at once.

Re: Update multiple records at once.

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: 2000/03/11
Message-ID: <38CA9071.7D96D8B1@rationalconcepts.com>#1/1

update state set region_no = 1 where state_cd IN ('VT', 'RI');

read up on Condition in the Oracle docs.

cheers,
cindy

liam_2e_at_my-deja.com wrote:

> Hello
>
> I was wondering how you would do a update for records.
>
> update state set region_no = 1
> where state_cd = 'VT', 'RI';
>
> What I tried to do here is set both of these two records to have a
> region number of one but it does not run?
>
> Thanks for the help Liam
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Mar 11 2000 - 00:00:00 CST

Original text of this message

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