updating a single value to multiple non consecutive rows

Posted on 16th Feb 2014 07:03 pm by admin

I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels.
I know I can update 1 with

SQL> update parcel
2 set expdate = sysdate
3 where prclid = 'A';

I imagin I need some thing like the following

SQL> update parcel
2 set expdate = sysdate
3 where prclid = 'A','C', 'D', 'G','E', 'J' ....

Your Answer:

Login to answer

Other forums

Date help - fetch dates for Mondays between xxx and yyy?
Does anyone know the best way to do this? I have two dates, say:

2010-01-26 and 2010-05-30

passing data from one page to another
hey guys
i have the follwoing code to get information from one page and place on another:

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

Calculating a rating by adding number of points and dividing by number of items
I have a site that users can post links to files to download. They can rate these files on a 1-5 sca

Chat Box in PHP
I was thinking in doing a Chat Box in PHP. For that I would use a form with two fields, Nick and Mes

How to file_get_contents when login required?
Hello!

I am trying to read data from a page that you have to be logged into to view, I am try

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

How to assign JS screen.width to ASP.Net variable
I've got this ASP.net routine that gets the cookie value of the screen width, but now I need to chan

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis