Re: Bitwise manipulation for an update statement.

From: <adrian.scott.day_at_gmail.com>
Date: 2 Dec 2004 02:59:35 -0800
Message-ID: <1101985175.632988.239100@c13g2000cwb.googlegroups.com>

Ok, sorry if I was unclear but Oracle programming is new to me.

The situation is this. I have a stored procedure which gets called repeatedly from a cursor. This stored procedure has 2 parameters. One being an id and the other being an integer. In the stored procedure I need to update about 50 columns for the record with the id that matches parameter 1.

Because there are so many columns that have to be updated, I was hoping that I wouldn't have to do a select statement to retrieve the existing values of those columns first.

Can you see my problem now? Received on Thu Dec 02 2004 - 04:59:35 CST