Adrian Scott-Day wrote:
>
> Could anyone shead some light on this problem that I'm faced with.
>
> I have a stored procedure that has 2 parameters. The first is the
> primary key for the table that is to be updated. The second is an
> integer. This integer is actually a bitwise status flag.(1=locked,
> 2=reviewed, 4=invalid...)
>
> The issue that I am facing is that I need to change the value for a
> large number of fields within this particular table, but only modify
> the relevant bits.
> For example record1 has a value of 4 in it's statusA field which means
> it is marked as invalid but not locked and not reviewed.
> Record1 has a value of 5 in it's statusB field which means it is
> marked as invalid and locked but not reviewed.
> The stored procedure then passes the primary key to select record1 and
> an integer value of 1, thereby indicating that the "locked" bit of the
> statusA and statusB fields should be set.
>
> How can I do this?
check out the bitand function
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
Coming Soon! "Oracle Insight - Tales of the OakTable"
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"
------------------------------------------------------------
Received on Sun Dec 12 2004 - 06:39:21 CST
