Oracle:Section5

Main Page >> Oracle and SQL >> Workbook >> Section 5 answers

Exercise 5.1

5.1 Insert a new employee to department 20, with a hiredate of the 1st January 2016 at 9am. Add appropriate values for the other columns.

INSERT  INTO  EMP
  VALUES  (8000,  'SMITH',  'ANALYST',  7566, TO_DATE('01-JAN-2016 9:00', 'DD-MON-YYYY hh:mi'), 3400,  0,  20);
COMMIT;

---

Return to the Workbook.