RE: bitand functions and NUMBER(20)
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: skuhn@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 19 Jul 2007 07:44:53 -0500
I have to ask this question because no one has yet given me an answer. Why do
you use an Oracle database to store bitwise data? Any performance gain you
might possible get by doing bitwise operations is going to be completely
overshadowed by the retrieval time from the database.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Stefan Kuhn
Sent: Thursday, July 19, 2007 7:18 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: bitand functions and NUMBER(20)
Hi all,
I have got a column defined as NUMBER(20) and want to use bit functions on it.
It seems that oracle bitand function is restricted in length. To give an
example:
select bitand(10846370260800065548,9368617832122679304) from TABLE;
returns 9.2234E+18, although the second figure is a subset of bits in first
figure. So result should be 9368617832122679304.
To make sure my figures are right, I did
select 10846370260800065548 & 9368617832122679304;
in Mysql and it gave 9368617832122679304.
The problem does arise with figures of a certain length.
What to do best (apart from changing the column type, which I would like to
avoid)?
I hope the question isn't too trivia...
Stefan
--
Stefan Kuhn BSc MA
IPB Halle
AG Bioinformatik & Massenspektrometrie
Weinberg 3
06120 Halle
http://www.ipb-halle.de http://msbi.bic-gh.de
skuhn@xxxxxxxxxxxx Tel. +49 (0) 345 5582 1474 Fax.+49 (0) 345 5582 1409
--
//www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
