Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Bit logic in SQL - is it possible?

Re: Bit logic in SQL - is it possible?

From: Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca>
Date: 2000/06/07
Message-ID: <hdw%4.1562$vT6.218341@news1.telusplanet.net>#1/1

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 Wed Jun 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US