View difference between Paste ID: 3CV7jeG8 and js9LFRes
SHOW: | | - or go back to the newest paste.
1-
CREATE TABLE EMT.LABORING (
1+
INSERT INTO LABORING(LAB_ID, LAB_NAME, LAB_BOSS_ID, DEP_ID, SALARY) VALUES
2-
  LAB_ID      NUMBER(38, 0),
2+
(1, 'Ганс', 2, 2, 100);
3-
  LAB_NAME    VARCHAR2(50 CHAR) NOT NULL,
3+
INSERT INTO LABORING(LAB_ID, LAB_NAME, LAB_BOSS_ID, DEP_ID, SALARY) VALUES
4-
  LAB_BOSS_ID NUMBER(38, 0),
4+
(2, 'Гимлер', 4, 2, 250);
5-
  DEP_ID      NUMBER(38, 0),
5+
INSERT INTO LABORING(LAB_ID, LAB_NAME, LAB_BOSS_ID, DEP_ID, SALARY) VALUES
6-
  SALARY      NUMBER(38, 0)     NOT NULL,
6+
(4, 'Гитлер', NULL, 1, 200);