Re: Bit logic in SQL - is it possible?

In article <960534082.4405.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Searched for it, this is the only one.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>

ops$tkyte_at_8i> select reverse( 'abc' ) from dual;

REV

---
cba






> 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

> > > >

> > >

> > >

> >

> >

>

>


--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.