Column length

[meghna]

Hi,

How to change the length of a column in oracle 8 ?

[gsprince]

ALTER TABLE
MODIFY(Column_Name Data_Type(Col_length))

Note, to reduce the Col_length, the all the values in the Column has to be null.

[gsprince]

ooops!

Posting got messed up. Here u go again,

ALTER TABLE Table_Name
MODIFY(Column_Name Data_Type(Col_length))


Ex,
Alter table test modify (deptno varchar2(15)) ;

Note, to reduce the Col_length, the all the values in the Column has to be null.