insert create emp
Post on 19-Dec-2015
215 Views
Preview:
DESCRIPTION
TRANSCRIPT
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);
top related