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

Inter Company -- Resources Related Billing (Services Industry)
Hello,

My company has a scenario where:
Company A bills Company C for INTER (cross

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

Problem with a select distinct
I have a problema with a select distinct, I have the next sql:

select distinct a,b,c,d fr

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer