 |
 |
Archives of the TeradataForum
Message Posted: Wed, 23 Jul 2003 @ 18:56:11 GMT
| Subj: | | Re: Alter table modify question |
| |
| From: | | Anantaraman, Kumaran (K.) |
From Oracle 9i manual :
datatype.. You can change any column's datatype if all rows for the column contain nulls....
...You can always increase the size of a character or raw column or the precision of a numeric column, whether or not all the
columns contain nulls. You can reduce the size of a column's datatype as long as the change does not require data to be modified. Oracle
scans existing data and returns an error if data exists that exceeds the new length limit.
Interesting.
Kumaran Anantaraman
| |
