The IS_BIT_SET function checks whether a specified bit in a RAW value is set.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this function.
Syntax
DBMS_UTILITY.IS_BIT_SET (
r IN RAW,
n IN NUMBER)
RETURN NUMBER;
Parameters
| Parameter | Description |
|---|---|
| r | The RAW value. |
| n | The bit position to check in the r value. |
Return value
This function returns 1 if the nth bit in the r value is set, and 0 otherwise. The highest bit is numbered 1, and the lowest bit is numbered 256.