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

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

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