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
Did you know?Explore Trending and Topic pages for more stories like this.
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

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i

url- go to webpage
i have an input text field and submit button.

how do i make the url entered into the textfiel

Trouble checking SESSION cookie
I am trying to use $_SESSION cookies to verify admin privileges .
I don't understand why this is

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

Linkage between two scripts
Okay say I have this for a link in a script:

Code: <li><a href="#&q

creating a 1 to 100 in a table
hi guys I am a newb in php need some help.

I have a table with 1 column and 100 rows and in

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