Re: pl/sql newbie

karl_72_at_msn.com (Karl) wrote in message news:<93c10f45.0302210731.43cc0541_at_posting.google.com>...
> Thanks in advance for your help. We have a pre-existing table that we
> just added a column to for a length of varchar6 and at the moment we
> filled with all o's. However I need to write a script that inserts a
> different value into those columns and it has to be the same value as
> a corresponding column in the same table. The one thing that makes
> this script difficult is that any new inserts into that table allowed
> new values (other than 0's) to be added. So i need to leave any value
> that is not equal to all 0's in this one column. I know that i need
> to do something like...if adjustment group is = to '000000' then do my
> insert and if not then ignore but i'm not sure of the exact sequence.
> thanks again.
> Karl

You mean "UPDATE" and not "INSERT". "INSERT" means a completely new row. "UPDATE" means changing existing value. In any case, see answer to your original post.

Regards
/Rauf Sarwar Received on Sat Feb 22 2003 - 01:59:48 CET