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' ....

No comments posted yet

Your Answer:

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

Pspell with my own dictionary
Hello!
I've tested two cases using pspell functions.
1)
Code: $dictionary_link = pspell_new

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Printing a webpage
I use this to print the webpage: o

Had a simple form script that suddenly stopped working
It was made about a year ago and had been working fine. Last time it was known to work for sure was

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

IP Logger for Voting Script
Can anybody help me place an IP logger into my voting script?
I know that maybe it is not as secu

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'

drop-down with sub-category appear
Hello,

i know how to build a simple dro-down list, im looking for a code when im gonna choose

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