View source for Oracle:Section5

[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|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-2015 9:00', 'DD-MON-YYYY hh:mi'), 3400,  0,  20);
 COMMIT;

----

Return to the [[Oracle_Workbook|Workbook]].