Oracle table

• 表格创建
  创建系表并插入记录：

SQL> CREATE TABLE TB_Dept         
  2  ( DeptID CHAR(2) PRIMARY KEY,
  3    DeptName CHAR(20) NOT NULL,
  4    DeptSetDate DATE,
  5    DeptScript VARCHAR2(500)
  6  );

• 表格数据更新

INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('02','机电工程系','1978-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('03','电子工程系','1978-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('05','化纺工程系','1978-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('06','外语系','1998-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('07','艺术设计系','1984-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('08','计算机系','2002-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('09','管理系','1978-9-1','略');
INSERT INTO TB_Dept (DeptID,DeptName,DeptSetDate,DeptScript) VALUES('10','基础部','1978-9-1','略');

• 表格删除
  SQL>drop TABLE TB_Dept;