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

Display certain image depending on time of year
Hi, I am new to these forums and would really appreciate some advice on a piece of coding I have don

Not "Just Another" MMORPG - text based.
Hello,

I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so

HTML Email rec'd as Source Code
The code does create and send the email successfully. However, the message shows as html code and n

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp

Track downloads' status
Hello,

I need to make somehow, some system, to track whether downloads are completed or faile

xml
<?php

echo "<h1>XML Articles</h1>";

$home

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match