> why do you need to do a "bitwise or" within sqlplus?
Good question... I have a really good engineer who is working with C and
Oracle OCI. He's developing an install routine and assures me that he needs
bitwise operators from SQL because he can do some really powerful things
with them. Then he said SQLServer and MySQL had them so the challenge was
on. Turns out I was able to give him what he wanted with a little bit of
help from something I found in a google search. There is an undocumented
bitand function in oracle and it appears it must be called from another
function. (Why?) You can see how this function is used in some of the data
dictionary view creation scripts. Here's and example of bitand...
SQL> select sum(bitand(12,11)) bitand from dual;
BITAND
----------
8
If you can get a bitand you can do a bitor...
SQL> select sum(12+11-bitand(12,11)) bitor from dual;
BITOR
----------
15
The math...
1100 "12"
1011 "11"
==== bitand
1000 "8"
1100 "12"
1011 "11"
==== bitor
1111 "15"
Not an alpha geek today,
Steve Orr
-----Original Message-----
Sent: Thursday, June 21, 2001 7:06 AM
To: Multiple recipients of list ORACLE-L
but, why do you need to do a "bitwise or" within sqlplus?
just curious.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, June 20, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L
OK, for the alpha geek award of the day...
Who can tell me how to do a "bitwise or" from SQLPlus -- NOT PL/SQL? Isn't
there an internal undocumented bitand function and how could you use that to
implement a bitor function from SQL?
Steve Orr
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
