Re: losing precision while selecting NUMBER values from Oracle 7.3

2004-09-22 Thread Ravi Kongara
Wieland and Tim, Thanks for your inputs. For now we want to go with ROUND function, that won't abruptly cut off digits and give back a reasonable value. But for that i now need to know the datatype of all columns in my query, which i am ignorant of so far!. Ravi Wieland Pusch wrote: Hello Tim and

Re: losing precision while selecting NUMBER values from Oracle 7.3

2004-09-21 Thread Tim Bunce
On Tue, Sep 21, 2004 at 12:30:17PM -0700, Ravi Kongara wrote: > Hi, > > I'm using DBI 1.42, DBD::Oracle1.14 built on Oracle 8, Perl 5.6.1 on > Solaris 9. > Purpose of the script is to compare values between source and target > databases. > Source db is Oracle 7.3 and target db is Oracle 8.1.7. >