ex_inserare1

INSERT INTO departments (department_id, department_name, manager_id, location_id)

VALUES(70,‘Public relation’, 100, 1700);

INSERT INTO departments (department_id, department_name)

VALUES(30,‘Purchasing’);

INSERT INTO departments

VALUES(30,‘Purchasing’, NULL, NULL);

INSERT INTOdepartments

(department_id, department_name, manager_id)

VALUES (300, ‘Engeneering’, DEFAULT)