2 ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld;
3 ALTER TABLE Scrips ADD Template VARCHAR2(200);
4 UPDATE Scrips SET Template = CAST(TemplateOld AS varchar2(200));
5 ALTER TABLE Scrips MODIFY Template VARCHAR2(200) NOT NULL;
6 ALTER TABLE Scrips DROP COLUMN TemplateOld;