Telling Reals from Integers
From: Michael J. Harper <mharper_at_well.sf.ca.us>
Date: Fri, 30 Oct 1992 02:36:02 GMT
Message-ID: <Bwwxw2.EDo_at_well.sf.ca.us>
Date: Fri, 30 Oct 1992 02:36:02 GMT
Message-ID: <Bwwxw2.EDo_at_well.sf.ca.us>
I would like to be able to differentiate between a real number and an integer in the results of a query. This query is ad-hoc and issued using OCI calls from a C program. There is a function, ODSC, which tells me what type each column is. However, both reals and integers come back as NUMBER types with no visible differentiation between the two.
Does anyone have any ideas about how I might figure out if I have a plain old integer on my hands?
Michael J. Harper
mharper_at_well.sf.ca.us
Received on Fri Oct 30 1992 - 03:36:02 CET