Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4461
  • Last Modified:

"Bitwise" operators?

Is there a way to do "bitwise" calculations in Oracle SQL?

Example in "pseudocode"

(4 BITAND 5) = 4 (100 "and" 101 = 100)
(40 BITAND 9) = 8 (101000 "and" 001001 = 001000)

and so on?
0
WernerVonBraun
Asked:
WernerVonBraun
2 Solutions
 
WernerVonBraunAuthor Commented:
Solutions in Oracle 8 compliant SQL please. That's our customers' lowest common denominator ...
0
 
morphmanCommented:
0
 
annamalai77Commented:
hi

check the link below

http://www.jlcomp.demon.co.uk/faq/bitwise.html

regards
annamalai
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
WernerVonBraunAuthor Commented:
0
 
annamalai77Commented:
hi there

this link will also help u.
http://www.orsweb.com/downloads/source/282.html

also the first one, i and another buddy has posted the same link twice. sorry for the trouble friend.

regards
annamalai
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now