Translator

Archive for January 2011

Oracle SQL: Create new column, renama a column, change data type of column

Oracle SQL Create new column:
alter table tablename1 add project_codes varchar2(3);

Oracle SQL Rename:
alter table tablename1 rename column project to projects;

Oracle SQL change data type:
alter table tablename1 modify projects varchar2(20);