pl/sql newbie

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 Received on Fri Feb 21 2003 - 16:31:11 CET