Oracle OCP基础知识复习--表修改列信息

Oracle OCP基础知识复习–表修改列信息

SQL Statement----modify table

alter table emp rename column age to myage;
ALTER TABLE emp ADD myaddress varchar2(20);
ALTER TABLE emp drop column age;
ALTER TABLE emp modify (age number(4,0);
ALTER TABLE emp MODIFY (address VARCHAR2(50));
alter table emp add ( myage varchar2(10));
alter table emp add(salary binary_float);
alter table emp modify(mysalary binary_double);