Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update multiple records at once.
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