Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: what datatype to use question

Re: what datatype to use question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 08 Apr 2003 22:39:43 +0200
Message-ID: <oqc69vo9eagmjqkad2s46s5hntl2n898kb@4ax.com>


On Tue, 08 Apr 2003 13:07:37 -0400, Jeff Kish <jeff.kish_at_mro.com> wrote:

>On Tue, 08 Apr 2003 12:45:09 -0400, Jeff Kish <jeff.kish_at_mro.com> wrote:
>
>>Greetings.
>>
>>
>>What datatype should I specify for a column that is to hold image extents?
>>The values can be for raster, pretty small or large integers,
>>and for vectors they can be in ranges like the following:
>>(-21234.5768, 21234.5678)
>>(-0.00332, .14234)
>>etc.
>>
>>
>>I am guessing that as long as I can guarantee 6 or 7 decimal places of accuracy, and hold up to 7 or 8 digits to the
>>left of the decimal place, I should be pretty safe, but I am unsure how to proceed, i.e.:
>>
>>CREATE TABLE TESTDOUBLE (
>> REALONE REAL ,
>> DECIMALONE DECIMAL ,
>> FLOATONE FLOAT ,
>> NUMBERONE NUMBER
>>)
>>Are one of these recommended? I don't "think" I'll have to do where searches on the column, but I can't guarantee that
>>it might happen in some obscure case.
>>
>>Thanks for your recommendations.
>>Jeff
>I'm leaning towards float. How can you tell the scale you get, i.e. number of digits to the right of the decimal point
>with using a certain type? I looked at all_user_tables and did not see anything for scale.. Does this mean it stores
>what it can?
>
>Thanks again,
>Jeff

REAL, FLOAT and DECIMAL have been designed for compatibility reasons and will all end up as NUMBER(38)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 08 2003 - 15:39:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US