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

Implementing Single Sign-On using SAML 1.1, x.509, LDAP in C#.net
Hi, I got a requirement from the client i.e implementing single sing on using SAML 1.1( LDAP &

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

Check if another session of the page is running?
I want to keep people from opening multiple tabs, or sessions of my Facebook app. Is it possible to

type check while uploading
Hi Everyone,

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

Here

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

Automatically Detect Phone Model for WAP Jar Deployment
Making a wap site is fairly simple, but I'd like to know if there's a way to make it so that the wap

MYSQL gen help
This is my Mysql gen. can anyone tell me why this echos

MID(networkset.networkid, 3, 3) AS &q