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

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

Shopping Cart
Can anyone direct me to a Simple, Basic structure of a shopping cart.
New to classes. I want to s

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

C - Reading a file into a byte array
Hi,

I'm trying to read a file into a byte array in C. I have to use C as this is for a loadru

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data