Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bit logic in SQL - is it possible?
Searched for it, this is the only one.
Regards,
Sybrand Bakker, Oracle DBA
Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca> schreef in berichtnieuws
hdw%4.1562$vT6.218341_at_news1.telusplanet.net...
> 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...
> > 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
> > >
> >
> >
>
>
Received on Fri Jun 09 2000 - 00:00:00 CDT