Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bit logic in SQL - is it possible?
for 816 need to put a to_char also as it fails without
SQL> SELECT TO_CHAR(bitand(5,3)) FROM dual;
T
-
1
SQL> SELECT bitand(5,3) FROM dual;
ERROR:
ORA-00932: inconsistent datatypes
Michel Cadot <micadot_at_netcourrier.com> wrote in message
news:8hlu0e$2kuc$1_at_s2.feed.news.oleane.net...
> There is bitand function:
>
> v734> select bitand(5,3) from dual;
>
> B
> -
> 1
>
> --
> Have a nice day
> Michel
>
>
> Adrian Harrison <a_harrison_uk_at_yahoo.co.uk> a écrit dans le message :
> k9rsjscm4fvfjno53sg0s9bg279564r66f_at_4ax.com...
> > Have a long int field that I want to test if individual bits are set i.e
> >
> > SELECT farm_code from nvz_visits_history where farm_type and 5;
> >
> > Doesn't like it - is it possible to do?
> >
> > Thanks
> >
> > Adrian Harrison
> >
>
>
Received on Fri Jun 09 2000 - 00:00:00 CDT