DEPT table dump

create table DEPT
(
    DEPT_ID VARCHAR(10),
    DEPT_NAME VARCHAR(50)
);

DROP TABLE DEPT;


select * from DEPT;

insert into DEPT values ('HR','Human Resource');
insert into DEPT values ('APS','Application Production Support');
insert into DEPT values ('DEV','Development');

Leave a Comment