Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> multiple update
I'm trying to update the records of multiple users in my database
with this query. The problem is that i have about 2000 email addresses and
will therefore need to update each one individualy.
Is there a way to change this query so that
e.g."where email = 'list, of , emails'
UPDATE USERS set NEWS_P = 't', NEWS_HTML_P = 't' where email = 'test_at_test.com'; Received on Tue Apr 16 2002 - 04:16:32 CDT