Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 11554 invoked from network); 19 Jul 2007 08:00:16 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 19 Jul 2007 08:00:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB166714582; Thu, 19 Jul 2007 08:57:58 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14269-06; Thu, 19 Jul 2007 08:57:58 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 35F63714926; Thu, 19 Jul 2007 08:57:58 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 19 Jul 2007 08:16:21 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3965C71562E for ; Thu, 19 Jul 2007 08:16:21 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04725-01-3 for ; Thu, 19 Jul 2007 08:16:21 -0400 (EDT) Received: from mailgate2.urz.uni-halle.de (mailgate2.urz.uni-halle.de [141.48.3.8]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C8497152D4 for ; Thu, 19 Jul 2007 08:16:20 -0400 (EDT) Received: from mserv2.urz.uni-halle.de ([141.48.3.146] helo=mserv2) by mailgate2.urz.uni-halle.de with esmtp (Exim 4.67) id 1IBUxg-00013a-6U for ; Thu, 19 Jul 2007 14:18:28 +0200 Received: from mail.ipb-halle.de (mail.ipb-halle.de [192.124.243.163]) by mail.uni-halle.de (iPlanet Messaging Server 5.2 HotFix 2.14 (built Aug 8 2006)) with ESMTP id <0JLF00EPXE63YX@mail.uni-halle.de> for oracle-l@freelists.org; Thu, 19 Jul 2007 14:18:03 +0200 (MEST) Received: from janz.ipb-sub.ipb-halle.de ([192.168.0.61]) by mail.ipb-halle.de with Microsoft SMTPSVC(5.0.2195.6713); Thu, 19 Jul 2007 14:18:03 +0200 Date: Thu, 19 Jul 2007 14:18:09 +0200 From: Stefan Kuhn Subject: bitand functions and NUMBER(20) To: oracle-l@freelists.org Message-id: <200707191418.09607.skuhn@ipb-halle.de> Organization: Leibniz-Institut fuer Pflanzenbiochemie MIME-version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-disposition: inline User-Agent: KMail/1.9.1 X-OriginalArrivalTime: 19 Jul 2007 12:18:03.0002 (UTC) FILETIME=[DA9E1DA0:01C7C9FE] X-Scan-Signature: 2a27d44df434fd149cba31a76cdfa34b X-archive-position: 51032 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: skuhn@ipb-halle.de Precedence: normal Reply-to: skuhn@ipb-halle.de List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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@ipb-halle.de Tel. +49 (0) 345 5582 1474 Fax.+49 (0) 345 5582 1409 -- http://www.freelists.org/webpage/oracle-l