title: How to use bitwise AND in WHERE clause?
body: <p>We have a FLAGS column in our DB which is used for storing various flags. This is a NUMBER column. The number will change depending upon the flags which are set. I want to select all the rows from a table for which  a particular flag is set. The flag can be obtained by doing a BITWISE AND on the column 'FLAGS' with the hex value: <code>0x0008000000000000L</code>.  How can I do it? I am a little new to Oracle SQL.</p>