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

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Can php detect connection speed and thereafter swap out elements?
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

pspell
using pspell, is it possible to get words that would be best in the current phrase?

For examp

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str

HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need t