Re: Bit logic in SQL - is it possible?

Kevin A Lewis wrote:
>
> Could you post a sample usage for this one - interesting
>
> Is it not documented anywhere
>
> Regards
>
> --
> Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
> Kingdom)
> <Kevin_A_Lewis_at_Hotmail.com>
>
> The views expressed herein by the author of this document
> are not necessarily those of BOCM PAULS Ltd.
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:960396492.26332.0.pluto.d4ee154e_at_news.demon.nl...
> > There is a more or less hidden bitand function that addresses this
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > Adrian Harrison <a_harrison_uk_at_yahoo.co.uk> schreef in berichtnieuws
> > 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
> > >
> >
> >

www.oracledba.co.uk/tips/bitwise_ops.htm

Cheers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse