Re: Oracle and Floating Points

One way would be to use trunc. For example: where trunc(c1)=123456789011

dixon_at_tlh.fdt.net wrote:

> I have an Oracle 7.2 database with Delphi 2 front-end applications
> connected through SQL Links 3.5 and SQL*Net (version 2, I think). I
> need
> to do lookups on one table based on a primary key. Unfortunately, the
>
> primary key was defined as a NUMBER, which is not always precise
> (because
> it's a floating-point). The keys in the database are all stored
> correctly, but the key I'm searching for sometimes becomes imprecise.
> If
> I search for 123456789012, the Oracle engine will look for
> 123456789011.999. The person who built the database and apps has
> since
> left the company, and I now have to fix this problem. I know the
> proper
> solution would be to change the column to a VARCHAR2 (or maybe
> NUMBER(12)
> - I'm new to Oracle, but I understand that's an integer), but that
> requires more time than we have available. Does anyone know of a
> workaround or a later version that solves this problem (although it's
> not
> really a bug)? TIA Michael Dixon dixon_at_tlh.fdt.net
>
> -------------------==== Posted via Deja News
> ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Thu Dec 04 1997 - 00:00:00 CST