Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2003 @ 18:56:11 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023