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

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

Add "width" check when upload
Hi!

Can someone add a function that is checking if picture witdh is bigger then 800px whwn up

media recovery
Hi,
i startup the database i got the error

SQL> startup
ORACLE instance started.

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

adding up might be solved tell us cheers.
i think i finally solved this anybody.

last time i was getting the wrong results.

Code

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL s

Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and place
I would like to have