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);
