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

read integers that returns a negative or prints the average
Im trying to finish this homework assignment by tommarow afternoon and I keep getting stuck.
Wr

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the

CURL question
i am wondering if it's possible to use multi curl with login something like

login once to web

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

Time-based image rotation script
I'm trying to write a PHP script that rotates an image based on what time of day it is. I want the

Using insert variable
need a way to inert variable data to mysql database

$acc = "212121212";
$nok =

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

Typing math
I've added support for typesetting math using LaTeX on the forums.

Example:
Code: [Select]

help retrieiving results and doing pagination
Having some trouble trying to get the results to show on more than just one page.

What is ha