 |
 |
Archives of the TeradataForum
Message Posted: Fri, 24 Feb 2006 @ 18:31:44 GMT
| Subj: | | Re: ORACLE NUMBER(38) equivalent in Teradata |
| |
| From: | | Geoffrey Rommel |
| | Is there any equivalent of ORACLE NUMBER(38) in Teradata? | |
At present, no. This, however, is the default precision for numbers in Oracle, so it is often used even when the numbers are small. I suggest
querying the source columns to see what the actual minimum and maximum values are. You may find, for instance, that they are only 0 to 999 and
could be loaded to a smallint.
| |
