create table dept (
dept_id char(4) not null primary key,
dept_name varcha(10) not null);
comment on column dept .dept_id is 部门代码;
comment on column dept .dept_name is 部门名称;
create table dept (
deptno char(4) not null primary key,
deptname varcha(10) not null);