Re: DATA TYPES

  Thanks Tim I appreciate you going through the trouble of showing the examples and such. Who said the world is made up of self serving greedy ones? :-> It turns out that I used a bad conversion function.

Tim Smith (tssmith_at_netcom.com) wrote:
: rt_at_astro.ocis.temple.edu (rt_at_astro.ocis.temple.edu) writes:
: is immaterial, but the precision will well accomodate several orders
: of magnitude more than 100,000).
 

: In any event, use NUMBER, and set the precision to however many
: digits you need. Looks like NUMBER(7,0) would work fine in your
: case.
 

: To show this, do the following in SQL*Plus or SQL*DBA:
 

: create table t1 (c1 integer, c2 number(4,0), c3 float, c4 number);
: insert into t1 values (123.4, 123.4, 123.4, 123.4);
 

: and then:
 

: select * from t1;
 

: which gets you:
 

: 123 123 123.4 123.4
 

: Of course this says nothing about the internal representation. So
: do:
 

: select dump(c1), dump(c2), dump(c3), dump(c4) from t1;
 

: to see the internal representation. You will see that the representation
: of all four is really the same, just that c1 and c2 have been truncated.
 

: --Tim (tssmith_at_oracle.com)

--
My mother may be the best mother in the world, but I ... am the baddest mother.