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

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..

type check while uploading
Hi Everyone,

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

Here

Why does first ever HttpSendRequest take longer?
I promise this isn't as simple as it sounds. I'm wondering why the the first ever call to HttpSendRe

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

a function to check directory depth
I'm working on a php script to upload files in to a set directory.
the user can select to upload

PHP doesn't send my mail
Hi all, I found this and used it to send mail. Simple contact form with some required fields. The va

SELECT * FROM users WHERE Users are not in Blocked
How do I select all users from users table where there users_id is not stored in the block table