Re: Mask

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 9 Nov 1999 15:56:21 +0100
Message-ID: <809cq6$2ko$1@oceanite.cybercable.fr>

Yes, you can use bitand function:

v734> select bitand(5,3) from dual;

B
-
1

To convert decimal<->hexadecimal, you can use the conversion functions that are in Thomas Kyte site at URL http://govt.oracle.com/~tkyte/

--
Have a nice day
Michel

Olivier BRUZEAUX <obruzeau_at_telecom.capgemini.fr> a écrit dans le message : 809c3p$rm4$1_at_minus.oleane.net...
>
> Is it possible to mask a field (with hexa number) in SQL SELECT command ?
>
> Thank you,
> Olivier
>
>
>
Received on Tue Nov 09 1999 - 08:56:21 CST