Re: Oracle Datatypes Question
Date: 28 Feb 1995 15:57:51 -0500
Message-ID: <3j02of$o8b_at_pegasus.rutgers.edu>
fhb_at_ornl.gov (Frances Butler) writes:
>I'm a newbie to Oracle, and have just begun to do some reading on
>this subject. I have consulted Oracle documentation, but I'm
>still confused. Here's the question: can you provide a brief
>novice-type explanation of when one would use an integer datatype
>versus a number datatype?
>Thanks in advance.
In oracle integers are stored internally as number.
Integer is equivalent to number(38).
Thus u could use integer or number(p) , where p is the desired precision.
hope this helps.
>-----------------------------------------------------
>Frances H. Butler e-mail: fhb_at_ornl.gov
>Computing Specialist
>Martin Marietta Energy Systems, Inc.
>Oak Ridge, TN
>-----------------------------------------------------
Received on Tue Feb 28 1995 - 21:57:51 CET