Solved

"Bitwise" operators?

Posted on 2004-08-12
6
4,452 Views
Last Modified: 2011-08-18
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
Comment
Question by:WernerVonBraun
6 Comments
 
LVL 4

Author Comment

by:WernerVonBraun
ID: 11782375
Solutions in Oracle 8 compliant SQL please. That's our customers' lowest common denominator ...
0
 
LVL 6

Accepted Solution

by:
morphman earned 25 total points
ID: 11782485
0
 
LVL 8

Assisted Solution

by:annamalai77
annamalai77 earned 25 total points
ID: 11782496
hi

check the link below

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

regards
annamalai
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Author Comment

by:WernerVonBraun
ID: 11782567
0
 
LVL 8

Expert Comment

by:annamalai77
ID: 11782642
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
 
LVL 48

Expert Comment

by:schwertner
ID: 11783282
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question