-- create a table
CREATE TABLE DEPT (
  DEPTMO NUMERIC(2) PRIMARY KEY,
  DNAME VARCHAR(20) NOT NULL,
  LOC VARCHAR(10) NOT NULL
);
-- insert some values
INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO');
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTAN');


-- fetch some values
SELECT * FROM DEPT