Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bit logic in SQL - is it possible?
8.0.5 needs it as well, though for different reasons:
SVRMGR> SELECT TO_CHAR(bitand(5,3)) FROM dual;
T
-
1
1 row selected.
SVRMGR>
SVRMGR> SELECT bitand(5,3) FROM dual;
1 row selected.
SVRMGR>
Regards.
Tony
-- S. Anthony Sequeira Totally committed to the fifty bucks Opinions expressed herein are my own and do not necessarily represent those of my employer Vipul Lakhani <vlakhani_at_cromwellmedia.co.uk> wrote in message news:8hqf39$or8$1_at_taliesin2.netcom.net.uk...Received on Tue Jun 13 2000 - 00:00:00 CDT
> 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
> > >
> >
> >
>
>