Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bit logic in SQL - is it possible?
Any other undocumented functions that you are aware of?
-- Terry Dykstra (TeamSybase) Canadian Forest Oil Ltd. Sybase Developer's Network: http://www.sybase.com/sdn "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:960396492.26332.0.pluto.d4ee154e_at_news.demon.nl...Received on Wed Jun 07 2000 - 00:00:00 CDT
> 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
> >
>
>
![]() |
![]() |