oracle表管理命令

1、创建表命令

CREATE TABLE student(
xh NUMBER(4),
xm VARCHAR2(20),
sex CHAR(2),
birthday DATE,
sal NUMBER(7,2)
);

2、修改表
ALTER TABLE student ADD classid NUMBER(2);
ALTER TABLE student MODIFY (xm varchar2(30));
ALTER TABLE student DROP COLUMN sal;
RENAME student to stu;
DROP TABLE student;