In my table I have one column InstituteID Number(5) which I have to make it to InstituteID Varchar(6) so my doubt is can I do this without deleting the data of the existing column. If it can be done can anyone suggest me how to do it?
Beksy Kurian
Ranch Hand
Joined: Jul 11, 2001
Posts: 254
posted
0
In 8i, the column has to be empty to change the datatype. Regards Beksy [ October 01, 2002: Message edited by: Beksy Kurian ]
0
