Re: Oracle/VB....can't we all just get along?

From: hazledid <david.hazledine_at_roche.com>
Date: Wed, 26 May 1999 13:30:36 GMT
Message-ID: <0IS23.1617$007.4108@c01read05.service.talkway.com>

I'm not familiar with VB, but if it permits vendor extensions to SQL you can do this in Oracle:

update users
set name = decode(user_id,1,'Steve',2,'Frank') where user_id in (1,2) ;

David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674

E-mail: david.hazledine_at_roche.com
Fax: +44 (0)1707 325666
Tel: +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Wed May 26 1999 - 08:30:36 CDT