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

Table Control
Hi Guru's,

I've created a Module pool program, which contains the Table Control.

Uploading/Downloading files stored in MySQL database
Hey all,

This problem just came up in my website and I'm having a hard time figuring out what

Get keys and values from an array
Hellow,

I have an array $Data with keys and values. With a foreach I can display all the valu

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

Buggy registration system
Hey, I just started scripting in PHP, and I ran into a few problems.
Code: <?php
includ

Printer configuration
Hi All,
Suppose one of the user deleted the printer settings unfortunatly ,then what is the pro

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

onclick problem
I have <input type="text" name="message">
<a href=page2.

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea