Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: BITAND function
Bitand function converts the two parameters into bit
strings of the same length and applies AND operation
between each bit and then converts to a number.
bit1 AND bit1 returns 1 if the two bits are 1 and 0 else.
For example:
create table t (col number);
insert into t values (0); insert into t values (1); insert into t values (2); insert into t values (3);
Vsevolod Afanassiev a écrit dans le message
<7pvbar$7p13_at_xlprod01.westpac.com.au>...
>Could someone tell me what BITAND function is?
>It is not documented ...
>Seems to be
>
> integer=bitand(integer,integer)
>
>It is used, e.g. to find enqueue name from V$SESSION_WAIT
>
>Thanks...
>Vsevolod
>
>
>
>
>
Received on Wed Aug 25 1999 - 03:04:57 CDT
![]() |
![]() |