DEPT table

CREATE TABLE Dept(
  Deptno NUMBER(10) PRIMARY KEY NOT NULL,
  Dname VARCHAR(20),
  Loc VARCHAR(40));


INSERT INTO Dept(Deptno,Dname,Loc) VALUES
(10,"Accounting","New York"),
(20,"Research","Dallas"),
(30,"Sales","Chicago"),
(40,"Operations","Boston");

SELECT * FROM dept;