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;