Oracle:Section5
From mi-linux
Revision as of 15:32, 4 March 2016 by Cm1958 (talk | contribs) (Protected "Oracle:Section5" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)))
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-2015 9:00', 'DD-MON-YYYY hh:mi'), 3400, 0, 20); COMMIT;
Return to the Workbook.