Re: How to find out if a NUMBER is actually a integer, float etc.

From: Tom Scott <tomscott_at_abac.com>
Date: Tue, 10 Nov 1998 08:22:03 -0800
Message-ID: <3648682B.FE664823@abac.com>

> the description of the select list items. The problem I have is that oracle
> returns the internal data type of NUMBER, whether the column is defined as
> integer, float or double precision. How can I find out if a particular
> NUMBER is an integer or a float? I tried to use the scale information, but
> looks like scale is not applicable for integer, real, double precision etc.

Look at the field Data_Scale in User_Tab_Columns.

--
Tom Scott

Remove "NoSpam." from email address to reply Received on Tue Nov 10 1998 - 10:22:03 CST