Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> multiple update

multiple update

From: scud <i_scud_at_hotmail.com.spam>
Date: Tue, 16 Apr 2002 09:16:32 +0000 (UTC)
Message-ID: <a9gq5g$qb6$1@paris.btinternet.com>


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

Original text of this message

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