Re: Bit logic in SQL - is it possible?

From: S. Anthony Sequeira <Sequeira_at_lineone.net>
Date: 2000/06/13
Message-ID: <8i5oer$3vl$1@supernews.com>#1/1

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...


> 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 Tue Jun 13 2000 - 00:00:00 CDT