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
Did you know?Explore Trending and Topic pages for more stories like this.
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' ....
No comments posted yet

Your Answer:

Login to answer
185 Like 7 Dislike
Previous forums Next forums
Other forums

newbie error
what is wrong with this code ?

<html>
<body>

<?

gmmktime or mktime
I live in the UK, i am within the GMT (with daylight saving time ie 1 hour difrence between summer a

Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

Help with php code
Hello, can anyone tell me why this php word trap fails to work,
and the trigger words get blow r

noob question
i traying to do a php form with auto replay for both(me and the user who send me a mail),

a u

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

Call Screen statement Error
Dear Experts,

is there any setting that needs to be done before creating any dialog progr

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

Empty text file when there is over XXXX lines of text.

define("RANDOM_FILE","/public_html/random.txt");
$randomEntry = "

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash