Difference between revisions of "Oracle:Section5"
From mi-linux
Jump to navigationJump to searchm (Protected "Oracle:Section5" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
|
(No difference)
| |
Revision as of 15:32, 4 March 2016
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.
