Control File Statements › Bit Test Statement › Examples
IF FLAG1 HAS ALL BITS OFF '04'.
The test is successful only if all of the bits in the flag are 0 (off).
SELECT IF FLAG1 HAS ANY BITS ON X'81'.