Insert Create Emp
If you can't read please download the document
-
Upload
emanuelpredescu -
Category
Documents
-
view
215 -
download
3
description
test
Transcript of Insert Create Emp
INSERT INTO "HR"."EMP" (EMPNO, NUMEEMP, VARSTAEMP, SALARIUEMP, DEPNO, EMPNOMANAGER) VALUES ('1', 'Vasilescu', '25', '1890', '1', '2');INSERT INTO "HR"."EMP" (EMPNO, NUMEEMP, VARSTAEMP, SALARIUEMP, DEPNO, EMPNOMANAGER) VALUES ('2', 'Popescu', '33', '3200', '2', '4');INSERT INTO "HR"."EMP" (EMPNO, NUMEEMP, VARSTAEMP, SALARIUEMP, DEPNO, EMPNOMANAGER) VALUES ('3', 'Stancioiu', '21', '2200', '1', '2');INSERT INTO "HR"."EMP" (EMPNO, NUMEEMP, VARSTAEMP, SALARIUEMP, DEPNO, EMPNOMANAGER) VALUES ('4', 'Gigel', '44', '4400', '2', '0');INSERT INTO "HR"."EMP" (EMPNO, NUMEEMP, VARSTAEMP, SALARIUEMP, DEPNO, EMPNOMANAGER) VALUES ('5', 'Ionescu', '34', '3000', '1', '4');create table emp( empNo char(10) primary key, numeEmp varchar(50) not null, varstaEmp decimal(3) not null, salariuEmp decimal(10) not null, depNo char(10), empNoManager char(10) not null);
