CREATE TABLE EMPLOYEE(     
EMP_NO INTEGER(5),     
EMP_NAME VARCHAR(10),     
EMP_SALARY INTEGER(8),     
EMP_COMM INTEGER(5),     
DEPT_NO INTEGER(5)     
); 

INSERT INTO EMPLOYEE VALUES(101,'SMITH',800,NULL,20); 
INSERT INTO EMPLOYEE VALUES(102,'SNEHAL',1600,300,25); 
INSERT INTO EMPLOYEE VALUES(103,'ADAMA',1100,0,20); 
INSERT INTO EMPLOYEE VALUES(104,'AMAN',3000,NULL,15); 
INSERT INTO EMPLOYEE VALUES(105,'ANITA',5000,50000,10); 
INSERT INTO EMPLOYEE VALUES(106,'SNEHA',2450,24500,10); 
INSERT INTO EMPLOYEE VALUES(107,'ANAMIKA',2975,NULL,30); 

SELECT * FROM EMPLOYEE ;